topic Re: Default selection using section access in QlikView

Default selection using section access

Anonymous — Sat, 31 Jan 2015 04:36:23 GMT

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.

Re: Default selection using section access

sujeetsingh — Sat, 31 Jan 2015 06:07:24 GMT

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

Re: Default selection using section access

Sat, 31 Jan 2015 06:27:44 GMT

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.

Re: Default selection using section access

prieper — Sat, 31 Jan 2015 09:12:53 GMT

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

Re: Default selection using section access

simongoodman — Tue, 17 Mar 2015 11:02:06 GMT

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

Re: Default selection using section access

prieper — Tue, 17 Mar 2015 14:00:02 GMT

As advised above: "A" or "B"

Peter