Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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() ?
That could be it... May be this:
=Index(Concat(DISTINCT Authorisation.username), OSUser()) > 0
May be like this:
=Match(Authorisation.username, OSUser())
or
=Index(Authorisation.username, OSUser())
I tried both, but did not work.
Is this because there are more users authorized for one and the same dimension ?
That could be it... May be this:
=Index(Concat(DISTINCT Authorisation.username), OSUser()) > 0
Thank you very much. This did it.
I would like to mark Sunny's answer as correct, Mark as usefull is the only possibility ??
You should be able to mark the correct response. Look here