Skip to main content
Announcements
Announcing Qlik Talend® Cloud and Qlik Answers™ to accelerate AI adoption! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Bert
Contributor
Contributor

Listbox Formula for selecting values

Hi,

I have running the qlinkview on the server. The Script is for all user the same.

Question:

I need to autofilter a listbox by the Result of the OSUser().

Is there any way to do it  (I cant do it by the loading of the csript).

Maybe i need a VBscript for this, starts when opening th Tab.

Thanks in advance!

Bert

 

Labels (1)
  • Other

1 Reply
marcus_sommer

You may apply an expression like:

if(match(osuser(), 'user1', 'user2') and Field = 'a', 'b', Field,
if(match(osuser(), 'user3', 'user4') and Field = 'x', 'y', Field, ...

By larger amounts of combinations of users and field-values such an approach could become quite tedious and such method won't secure confidential data.

Therefore it would be more suitable in the most scenarios to do this within the script, for example with Section Access - Qlik Community - 1493681.

- Marcus