topic Section Access AND Initial Selection in QlikView

Section Access AND Initial Selection

Anonymous — Thu, 16 May 2013 14:17:13 GMT

Is it possible to use Section Access in the script and also set an Initial Selection. Normally I would simply set an Initial Selection for all users by just saving the QVD with the selection active, but Section Access just removes it on opening. It would be useful to have different Initial Selections for different users but at this point I'd settle for all getting the same.

Thanks,

Re: Section Access AND Initial Selection

Gysbert_Wassenaar — Thu, 16 May 2013 14:41:25 GMT

You could create a table with the username (use the same field name as in the section access table) , field and the selections. The selections should be separated by pipe symbols '|'.

User Field Selections

---- ----- ----------

John DimA a|b|d

John DimB 1|5

Pete DimA c|d|f

Pete DimB 2|,5

You can add Select in Field actions to the OnOpen document trigger to set the selections. For example for field DimA the search string would be ='(' & only({<Field={'DimA'}>} Selections) & ')'.

Re: Section Access AND Initial Selection

Anonymous — Thu, 16 May 2013 14:54:50 GMT

Yep that worked perfectly, thanks.