conditional show expression or dimension

[curiousfellow]

I have a table with usernames and a key linking to other data.

Now I want to conditional show expressions or dimensions

For that I use : OSuser()= Authorisation.username

When comparising both values Qlik says they are the same, but data do not show.

Can I use conditonal with OSuser()  ?

[sunny_talwar]

May be like this:

=Match(Authorisation.username, OSUser())

or

=Index(Authorisation.username, OSUser())

[curiousfellow]

I tried both, but did not work.

Is this because there are more users authorized for one and the same dimension ?

[sunny_talwar · Accepted solution]

That could be it... May be this:

=Index(Concat(DISTINCT Authorisation.username), OSUser()) > 0

[curiousfellow]

Thank you very much. This did it.

[curiousfellow]

I would like to mark Sunny's answer as correct, Mark as usefull is the only possibility ??

[sunny_talwar]

You should be able to mark the correct response. Look here

Qlik Community Tip: Marking Replies as Correct or Helpful