topic How to dynamically set selection values in listboxes "on open" of document based on userid in QlikView

How to dynamically set selection values in listboxes "on open" of document based on userid

Tue, 24 Nov 2015 12:28:31 GMT

Dear Community,

We've a requirement: based on the userid who opens the QVW we would like to

1. retrieve the job he does via Lookup from a resident table

2. set the jobtype into a parameter

3. and set the job as a selection

when opening the document so "on open" of the document.

any ideas would be welcome...

cheers

Mark_Little — Tue, 24 Nov 2015 13:03:49 GMT

HI,

Have you look at sections access?

Another option would be to make a Trigger OnOpen, but it could be a complicated if statement, to get the right fields.

Like if(OSUSer() = 'A', 'BO'

if(OSUSer() = 'B'

Maybe have bookmarks that have the selection your want and then you can use the above if idea to apply the the right bookmark on open?

Mark