Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

hide some tabs from some users

Hi guys,

I am trying to use security to hide some tabs from users as follow:

on the tab properties--> Conditional  i am using:

(Match(Upper(OSUser())

        'na\AlecHarf'

        ) = 0)

and for some reason it is not working

but if i do

(Match(Upper(OSUser())

        'na\SamSmith'

        ) > 0)

then sam is the only one sees the tab.

I could've used the second formula but i have hundreds of users and I am trying to hide the tab from only 3 users

Any suggestions?

Thxs in advance,

Alec

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

na\AlecHarf is not in uppercase so it won't ever match the output of upper(OSUser())

Try this expression to hide the tab for Alec Charf, Sam Smith and username3:

not match(upper(OSUser()),'NA\ALECHARF','NA\SAMSMITH','NA\USERNAME3')


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

na\AlecHarf is not in uppercase so it won't ever match the output of upper(OSUser())

Try this expression to hide the tab for Alec Charf, Sam Smith and username3:

not match(upper(OSUser()),'NA\ALECHARF','NA\SAMSMITH','NA\USERNAME3')


talk is cheap, supply exceeds demand
alec1982
Specialist II
Specialist II
Author

Thxs for your help