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

Current Selection Conditional Values

Hello,

I have a selection box for a user Geography level with 4 values - A,B,C,D.

I would like to use the 'expression' in field to make a condition that if a certain user logs in (securities applied) then they see a certain set of values. The various levels were loaded as inline's so Securities do not reduce them. ie:

User 1: A

User 2: A,B

User 3, A,B,C,D

The issue that I am having is that I have been getting back 1,0,-1 and not original letter values.

I was thinking along the lines of this:

if(User='User 1', Level='A',(if(User='User 2', Level='A' or Level='B', Level))

How can i achieve this.

Thank you.

4 Replies
sunny_talwar

You might be able to use OSUser() function

If(OSUser() = 'blahblah', then this, else do that)

Not applicable
Author

The issue that i am having is the returned values in the Selection box

sunny_talwar

Not sure if I understand, is it possible for you to share a sample?

dionverbeke
Partner - Creator III
Partner - Creator III

I would use Section Access to achieve this and attach the fields there.

This is automatically applied when you log in to the document and actually best practice.

Dion