topic Listbox Formula for selecting values in QlikView

Listbox Formula for selecting values

Bert — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Listbox Formula for selecting values

marcus_sommer — Tue, 07 Jun 2022 07:19:29 GMT

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