topic Re: Current Selection Conditional Values in QlikView

Current Selection Conditional Values

Wed, 15 Jul 2015 19:31:02 GMT

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.

Re: Current Selection Conditional Values

sunny_talwar — Wed, 15 Jul 2015 19:48:05 GMT

You might be able to use OSUser() function

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

Re: Current Selection Conditional Values

Wed, 15 Jul 2015 19:51:01 GMT

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

Re: Current Selection Conditional Values

sunny_talwar — Wed, 15 Jul 2015 19:52:26 GMT

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

Re: Current Selection Conditional Values

dionverbeke — Wed, 15 Jul 2015 19:56:42 GMT

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