Hiding sheets in QVW

Anonymous — Mon, 12 Feb 2018 21:24:26 GMT

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.

Re: Hiding sheets in QVW

sergio0592 — Mon, 12 Feb 2018 22:31:39 GMT

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.

topic Hiding sheets in QVW in QlikView

Hiding sheets in QVW

Re: Hiding sheets in QVW