topic Re: Section Access: Combine 'Data reduction' and 'Initial Selection' in QlikView

Section Access: Combine 'Data reduction' and 'Initial Selection'

Mon, 13 Jul 2015 12:49:46 GMT

Hi all,

In a QlikView document I am succesfully applying Section Access (although it is applied via an excel file, for simplification I show it as an Load Inline Table here):

Section Access;

Load * Inline [

NTNAME, ACCESS, REDUCTIONFIELD

Admin, Admin, *

USER_A1, User, A

User_B1, User, B,

User_B1, User, B

];

Section Application;

However I would also like to make an automatic selection after a user had logged in. Preferably based on a different field (let's call it 'SELECTIONFIELD'). However for this field no data reduction - the user must be able to manually make a different selection in the samen field.

Eg.: When User_B1 does a login, the data is reduced according to 'B'. After the dashbaord has been opened, it also shows an active selection on 'SELECTIONFIELD' (SelectB1). If User_B2 opens the dashboard, the same reduction is applied (according to 'B') however his active selection is 'SelectB2'.

Can this be done?

Koen

Re: Section Access: Combine 'Data reduction' and 'Initial Selection'

giakoum — Mon, 13 Jul 2015 12:53:13 GMT

2 ways:

- either you write a complex OnOpen trigger (not convenient if you have many users

- or you set a table with user and SelectB2 fields, and then use this table as set analysis in your expressions or as an OnOpen trigger as option 1

Re: Section Access: Combine 'Data reduction' and 'Initial Selection'

Mon, 13 Jul 2015 13:24:06 GMT

Hi Ioannis,

Option 2 looks like an interesting path to follow. However I am not yet

there.

I created the following table:

Groups_Selection:

LOAD USER,

Group

FROM

(ooxml, embedded labels, table is Section_Application)

;

With e.g. USER = User_B1; Group = SelectB1, USER = USER_B2, Group =

SelectB2.

I create an OnOpen Trigger with command:

Select in Field: Field x ; Value = Group

However this does not have any effect. no selections are made.

Regards,

Koen

On Mon, Jul 13, 2015 at 2:54 PM, ioannis giakoumakis <

Re: Section Access: Combine 'Data reduction' and 'Initial Selection'

giakoum — Mon, 13 Jul 2015 13:53:48 GMT

no selections are made even when using the desktop client?

Re: Section Access: Combine 'Data reduction' and 'Initial Selection'

Mon, 13 Jul 2015 14:26:07 GMT

Hi Ioannis,

No selection is made:

Re: Section Access: Combine 'Data reduction' and 'Initial Selection'

Mon, 13 Jul 2015 15:51:26 GMT

Hi Ioannis (and other),

Maybe I wasn't clear enough. However, your answer did indicate in the right direction, so I'll like it:).

The total solution was:

Include the field in the Section Application part; so

Section Access;

Load * Inline [

NTNAME, ACCESS, REDUCTIONFIELD, SELECTIONFIELD

Admin, Admin, *, *

USER_A1, User, A, *

User_B1, User, B, B1

User_B2, User, B, B2

];

//Load * Inline can be an excel or qvd table as well.

Section Application;

However 'SELECTIONFIELD' should not exist in the original data (or data will be reduced via row filters).

You can then add on the row below Section Application an extra table with

//Load * Inline can be an excel or qvd table as well. Be sure to load distinct.

Load * Inline [

SELECTIONFIELD

B1,

];

This field is reduced to one value - which you then can use as trigger field to make a selection (e.g. OnOpen)

Re: Section Access: Combine 'Data reduction' and 'Initial Selection'

Mon, 13 Jul 2015 15:57:23 GMT

To add: it does not work in combination with 'Strict Exclusion', leave only 'Data Reduction upon...' switched on.