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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sat_tok52
Creator
Creator

User OSUSER() show if column in Qlik Sense

Hi All,

I have user list with  NTNames, as per my requirement i have to show only few users  table column data in qlik sense.

I have tried OSUSER () , By using subfield function I have trimmed this osuser() same like my NTname.I have written expression in show if column area like below , but it's not working any help.

 

If(user=OSuser(),USer)

 

Thanks.

Labels (1)
1 Reply
lironbaram
Partner - Master III
Partner - Master III

hi 

in order for this to work 

you need to have a filed user with the list of all users that can see the column 

than you can use :

if (wildmatch(concat(user , ',') ,'*' & osuser()& '*')>0,1,0)