topic Re: Hide List Box Based on User in QlikView

Hide List Box Based on User

racer25 — Mon, 31 Aug 2015 14:15:05 GMT

Hi Everyone.

Please forgive me if I have not searched very well for this. I found lots of complex challenges with complex solutions and I believe what I am doing is far more simple ( I hope ).

I have granted access to a Qlikview Document through section access based on NT logon - so essentially no username and passwords required by the end user. For admin/testing purposes only I have a list box where I can click on a username and see their effective access (which teams etc). All this works well and 100+ users are happy.

What I would like to be able to do is make the aforementioned ListBox visible to 3 people ( me and two admin ). I have not done this before so would appreciate the full hand hold 🙂

Looking for simple I hope (If user = jsmith1 or user =admin1 or user = admin2 then visible)

Many thanks,

Rob

Re: Hide List Box Based on User

maxgro — Mon, 31 Aug 2015 14:19:46 GMT

you can use the OSUser function to check the user in layout tab of the listbox, show conditional

this is from QlikView help

OSuser( )

Returns a string containing the name of the current user as returned by the operating system.

Re: Hide List Box Based on User

racer25 — Tue, 01 Sep 2015 09:44:03 GMT

Hi Massimo,

I tested OSUser() but not sure how I would allow 3 users to see the listbox.

Can you elaborate a little please?

Thanks,

Rob

Re: Hide List Box Based on User

maxgro — Tue, 01 Sep 2015 19:09:49 GMT

=mixmatch(OSUser(), 'domain\user1', 'domain\user2', 'domain\user3')

from QlikView help

mixmatch( str, expr1 [ , expr2,...exprN ] )

The mixmatch function performs a case insensitive comparison.

Example:

mixmatch( M, 'Jan','Feb','Mar')

returns 1 if M = jan

if OsUser() is one of the 3 users, the expression returns a positive integer --> listbox is visible

if not, the expression returns 0 --> listbox not visible

you can also use the expression you already posted

=if(OsUser() = '.......' or OsUser()= '......' or OsUser() = '.....', 1, 0)

Re: Hide List Box Based on User

Tue, 01 Sep 2015 19:37:53 GMT

Please try this, if you think this is simple to follow.

Add one more new column in section access file, which takes value (1 or 0).

1 - for user, whom you want to display list box.

0 - for others.

Example: I have added Export as new column which takes binary value.

LOAD ACCESS,

NTNAME,

EXPORT

FROM

[$(vDOCPath)\Tab_Access.xlsx]

(ooxml, embedded labels, table is Access);

Access table

ACCESS	NTNAME	EXPORT
ADMIN	QlikView Admin	1
USER	a	1
USER	b	1
USER	c	0

Use the binary column in show condition (Here it is sheet property. You can do same for other objects also)

Thanks,

Vinod Kumar V