Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
New Contributor III

Hiding sheets in QVW

Hello,

I need to hide sheets in the access points for 5 users. I'm using the syntax =if(osuser() = 'EXCHANGE\ABC',0,1) under sheet properties > General > Conditional. It works well in the Access point that the user ABC can no longer see the tab/sheet.

My question is regarding how to implement the same logic for other 4 users within the same syntax. Can we use =if(osuser() = 'EXCHANGE\ABC', 'EXCHANGE\DEF', 0,1). What is the correct way of implementing it.

1 Solution

Accepted Solutions
Highlighted
Valued Contributor II

Re: Hiding sheets in QVW

Hi, try with :

=if(match(osuser(), 'EXCHANGE\ABC', 'EXCHANGE\DEF')>0,0,1)


But in OS user name there is often differents case letter eg Jason_COOPER, Brenda_Trafford. So i often use mixmatch() function instead.

View solution in original post

1 Reply
Highlighted
Valued Contributor II

Re: Hiding sheets in QVW

Hi, try with :

=if(match(osuser(), 'EXCHANGE\ABC', 'EXCHANGE\DEF')>0,0,1)


But in OS user name there is often differents case letter eg Jason_COOPER, Brenda_Trafford. So i often use mixmatch() function instead.

View solution in original post