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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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