topic conditional show expression or dimension in QlikView

conditional show expression or dimension

curiousfellow — Tue, 20 Dec 2016 15:17:13 GMT

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 — Tue, 20 Dec 2016 15:21:05 GMT

May be like this:

=Match(Authorisation.username, OSUser())

=Index(Authorisation.username, OSUser())

curiousfellow — Wed, 21 Dec 2016 10:34:27 GMT

I tried both, but did not work.

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

sunny_talwar — Wed, 21 Dec 2016 10:41:46 GMT

That could be it... May be this:

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

curiousfellow — Wed, 21 Dec 2016 11:57:16 GMT

Thank you very much. This did it.

curiousfellow — Wed, 21 Dec 2016 12:04:32 GMT

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

sunny_talwar — Wed, 21 Dec 2016 12:07:00 GMT

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