Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted
MVP & Luminary
MVP & Luminary

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

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

View solution in original post

Highlighted
Contributor III
Contributor III

Yep that worked perfectly, thanks.