Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

venkat_94b4
Contributor

Default selection using section access

Hello Comm.,

if i have 1000 users for my document, how can i do different default selections for different users and how to do data reduction based on user.any help would be great to me.

Thanks in Advance.

Regards,

Venkat.

5 Replies
sujeetsingh
Honored Contributor III

Re: Default selection using section access

You can have the Bookmark for each user and set section access based on the bookmark please check whether it is possible

Highlighted
Not applicable

Re: Default selection using section access

I think the best way to achieve both reduction and default selection is to:

a. Make use of Initial Data Reduction setting (Doc Props--Opening)

b. Create a document level trigger - Doc Props -- Triggers -- OnOpen to apply a default selection by using the Action setting 'Select in Field'. Please note that OnOpen trigger is not compatible with AJAX client.

prieper
Honored Contributor II

Re: Default selection using section access

Datareduction via Section Access is a must - has been advised.

In the loadscript you may load a separate table with the initial setting per user (as INLINE or external).

This value then might be handed into a variable, which is taken as selection in the a.m. ONOPEN-trigger.

Edith says that I may attach an example for better understanding:

Edith also says, that it might be better to give a hint for the allowed users: A or B should do (sorry for omitting, section access works)

HTH Peter

simongoodman
Contributor

Re: Default selection using section access

Hi Peter To look at the app what is the USERID login? Thanks Simon

prieper
Honored Contributor II

Re: Default selection using section access

As advised above: "A" or "B"

Peter