topic Re: Show Conditional Sheet for Users in QlikView

Show Conditional Sheet for Users

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I need to show a particular sheet for specific users. I'm trying to use something like:

=WILDMATCH(OSUser(),Concat(DISTINCT UserList,', ')

But it doesn't work. Do you know how could I do that?

OSUser() is my user, for example User03

The Field UserList contains all Users, for example: User01, User02, User03, User07

Thanks

Re: Show Conditional Sheet for Users

Anonymous — Thu, 08 Sep 2016 16:03:49 GMT

Section Access;

ACCESS, USERID

Section application;

Star is *;

UserID,Tab

X, Sales

Y, Share,

....Z, *

Users with Sales access or all sheets access by

(SubStringCount(MaxString(Tab),'SALES')>0 or SubStringCount(MaxString(Tab),'*')>0)

Re: Show Conditional Sheet for Users

karthiksrqv — Thu, 30 Mar 2017 06:45:53 GMT

Please refer to this thread:

WildMatch not working

You'll need to use Dollar Sign Expansion.

Also, wildmatch will return a 0 if the user is not found in the list, you'll have to put this into the 'Conditional' part of the Sheet Properties > General setting.

Re: Show Conditional Sheet for Users

beck_bakytbek — Thu, 30 Mar 2017 07:28:15 GMT

Hi Micro,

look at this great post, i am sure you can solve your issue,

https://www.youtube.com/watch?v=LimUIy164d4

i hope that helps

beck

Re: Show Conditional Sheet for Users

avinashelite — Thu, 30 Mar 2017 07:49:35 GMT

Try like this

=WildMatch(OSUser(),$(=chr(39)&Concat(DISTINCT UserList,chr(39)&','&chr(39))&chr(39)))

Re: Show Conditional Sheet for Users

sunny_talwar — Thu, 30 Mar 2017 08:19:38 GMT

May be this

SubStringCount('|' & Concat(DISTINCT UserList, '|,|') & '|', '|' & SubField(OSUser(), '\', -1) & '|') = 1

Re: Show Conditional Sheet for Users

tamilarasu — Thu, 30 Mar 2017 08:20:48 GMT

Hello,

Try this,

= WildMatch(OSUser(), $(=Concat( DISTINCT chr(39) & '*' & UserList & '*' & chr(39) , ', '))) >0

Re: Show Conditional Sheet for Users

tamilarasu — Thu, 30 Mar 2017 08:42:59 GMT

Hi Sunny,

You forgot to inform that UserList field names should match exactly with the OSUser i.e case sensitive.

Re: Show Conditional Sheet for Users

sunny_talwar — Thu, 30 Mar 2017 08:45:34 GMT

But I didn't see that in OPs intial post that his UserList may not have correct casing? If it won't be, then I guess you are right... but something like a username, I would expect to have been copy and pasted from a database which I would expect to have correct casing....

Re: Show Conditional Sheet for Users

tamilarasu — Thu, 30 Mar 2017 08:52:09 GMT

Sunny I just mentioned it so that we will be on the safer side in case of unexpected scenario.

Cheers

Re: Show Conditional Sheet for Users

sunny_talwar — Thu, 30 Mar 2017 08:53:37 GMT

Makes sense