New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Qlik Exam QSBA2024 Topic 4 Question 3 Discussion

Actual exam question for Qlik's QSBA2024 exam
Question #: 3
Topic #: 4
[All QSBA2024 Questions]

A company has sales data where every Customer ID can be assigned to one or more Sales Account ID. Sales Accounts are assigned to one of eight Groups. The business analyst is creating an app with the following requirements:

* Each Group should have a separate sheet

* The Sales Account can only see its own customers

* The Sales Account can navigate only to the sheet for the Group assigned

The business analyst has created a Section Access table, in which each Sales Account ID is assigned their CustomerlDs. Which action should the business analyst take next?

Show Suggested Answer Hide Answer
Suggested Answer: C

The most effective way to control sheet access based on group assignment is to use the Group field in the Section Access table and apply it to the show/hide condition of the sheets. Each Sales Account ID is already mapped to a Group, so the business analyst can use this Group field to dynamically control which sheets are visible based on the user's Group assignment. This ensures that each Sales Account only sees their respective Group's sheet.

Key Concepts:

Section Access with Groups: By incorporating the Group field into Section Access, the analyst can restrict sheet visibility based on group membership.

Show/Hide Condition: This feature in Qlik Sense allows certain sheets or objects to be displayed or hidden based on conditions, in this case, the user's group.

Why the Other Options Are Less Suitable:

A . Sales Account ID as a filter: The Sales Account ID is used for data filtering but is not the appropriate condition for controlling sheet visibility.

B . Group as a filter on the sheet: While Group can be used as a condition, it must be managed through Section Access to ensure proper visibility control.

D . OSUser() function: While OSUser() can capture the user's login information, using the Group field in Section Access is more efficient for controlling access to specific sheets based on group assignments.

References for Qlik Sense Business Analyst:

Show/Hide Sheets Based on Section Access: Qlik Sense supports the use of Section Access for controlling access to sheets based on user roles and group assignments.

Thus, C is the most appropriate solution because it uses the Group field within Section Access to control sheet visibility, making it the correct answer.


Contribute your Thoughts:

Kiley
1 months ago
Is it just me, or does this question sound like it's straight out of a corporate PowerPoint presentation? Gotta love these real-world business scenarios they throw at us.
upvoted 0 times
...
Muriel
1 months ago
I'm torn between A and C, but I think C is the cleaner solution. Keeping the logic separate from the sheet visibility conditions is probably the best approach here.
upvoted 0 times
Virgina
2 days ago
That sounds like a good plan. It will make it easier to manage in the long run.
upvoted 0 times
...
Naomi
19 days ago
Agreed, using the Group field in the Section Access table makes sense.
upvoted 0 times
...
Coletta
23 days ago
I think C is the way to go. It keeps things organized.
upvoted 0 times
...
...
Kayleigh
2 months ago
Haha, the OSUser() function? I bet someone just wanted to throw in a curveball option there. Definitely not the right choice for this scenario.
upvoted 0 times
...
Twanna
2 months ago
Option C seems like the way to go. Using the Group field in the Section Access table and applying it to the sheet visibility makes the most sense to me.
upvoted 0 times
Kendra
18 days ago
C) Use the Group field within the Section Access table, then apply it to the show/hide condition of the sheets
upvoted 0 times
...
Mable
19 days ago
B) Use the Group as a filter on the show/hide condition on the relevant sheet
upvoted 0 times
...
Quentin
20 days ago
A) Use the Sales Account ID as a filter on the show/hide condition on the relevant sheet
upvoted 0 times
...
...
Hermila
2 months ago
I agree with Scarlet. Using the Group as a filter on the show/hide condition on the relevant sheet makes the most sense in this scenario.
upvoted 0 times
...
Scarlet
2 months ago
I think the business analyst should use the Group field within the Section Access table and apply it to the show/hide condition of the sheets.
upvoted 0 times
...

Save Cancel