Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
richcook
New Contributor III

Section Access AND Initial Selection

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,

1 Solution

Accepted Solutions

Re: Section Access AND Initial Selection

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) & ')'


talk is cheap, supply exceeds demand
2 Replies

Re: Section Access AND Initial Selection

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) & ')'


talk is cheap, supply exceeds demand
richcook
New Contributor III

Re: Section Access AND Initial Selection

Yep that worked perfectly, thanks.

Community Browser