topic Help with conditional show of a test object in QlikView

Help with conditional show of a test object

dseelam — Mon, 07 Nov 2016 21:46:47 GMT

hello all,

How to conditionally show text object to only 3 osusers just say tom, frank & eli

and hide it from other users ??

Re: Help with conditional show of a test object

Nicole-Smith — Mon, 07 Nov 2016 21:49:14 GMT

Put the following in Layout > Show > Conditional:

=match(OSUser(), 'tom_username', 'frank_username', 'eli_username')

Re: Help with conditional show of a test object

dseelam — Tue, 08 Nov 2016 14:27:37 GMT

Hello Nicole,

Thanks for the reply

When I use condition above, some how its hidden from my screen even I did added my self in condition

Its not working

Re: Help with conditional show of a test object

sunny_talwar — Tue, 08 Nov 2016 14:33:35 GMT

I think OSUser() outputs more than just the user_name. It adds the domain name also. So, I would suggest using WildMatch(), SubStringCount() or Index() functions instead of using Match

=WildMatch(OSUser(), '*tom_username', '*frank_username',....)

or extract the user_name from OSUser and then use it with Match

=Match(Subfield(OSUser(), '\', 2), 'tom_username', 'frank_username', 'eli_username')

Re: Help with conditional show of a test object

swuehl — Tue, 08 Nov 2016 14:34:03 GMT

Check with a text box object what is returned for OSUser().

Also double check the spelling of your user name in the match() function, AFAIR, it's case sensitive.

Re: Help with conditional show of a test object

johnca — Tue, 08 Nov 2016 14:34:23 GMT

I think your usernames need to be fully qualified including the domain with the domain capitalized, so modify Nicole's reply to:

=match(OSUser(), 'ABC_CO\tom_username', 'ABC_CO\frank_username', 'ABC_CO\eli_username').

HTH,

John

Re: Help with conditional show of a test object

dseelam — Tue, 08 Nov 2016 15:05:25 GMT

Hey Sunny,

this expression worked for KPI

=WildMatch(OSUser(), '*tom_username', '*frank_username',....)

can I hide the same KPI as expression in straight table using same kind of condition ??

my expression is in variable (vShipcurrentOnTimeAmtPct)

Re: Help with conditional show of a test object

sunny_talwar — Tue, 08 Nov 2016 15:08:12 GMT

I think you should be able to do that, is it not working?

Re: Help with conditional show of a test object

dseelam — Tue, 08 Nov 2016 15:11:01 GMT

On text object its working as it has conditional show and hide

how to use same condition in straight table only for one field to show for only OSUSERS ?

Re: Help with conditional show of a test object

sunny_talwar — Tue, 08 Nov 2016 15:14:06 GMT

Both dimensions and expressions have conditional show hide. Use them....

Dimension

Expressions

Re: Help with conditional show of a test object

dseelam — Tue, 08 Nov 2016 15:16:50 GMT

Thank you sunny it worked