Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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

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