Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pre-selected dynamic dimension selection based on user role

Hi Community user,

I have 3 users A, B and C, each user is in charge of one department X, Y and Z. Although user A is in charge of department X but the information for the other 2 departments Y and Z will also be available for user A to have a look.

In such a case, user A requires that once qvw app is opened based on his account access, department X will be pre-selected in department dimension. But once he clears department X selection in department dimension, he is able to select other 2 departments as well.

User B and C require the same set up for them as well. So is there a dynamic way to trigger the action for dimension selection base on user's role at the time the app is open?

Thanks a lot.

1 Reply
sunny_talwar

You should be able to to use dynamic OnOpen trigger using OSUser() or QVUser() functions. For Exact syntax you will have to play around with it.