Section Access Help

[satishkurra]

Hi

Using the below section access script, i assume user ADAM has ADMIN access and he should be able to see all the data as i represented in * and User PETER should be able to see only JCPenney.

Not sure what is happening, when i log with ADAM, i see only JCPenney.

Can someone help me on the same.

In b/w the below things are taken care

I have “Initial Data Reduction Based on Section Access” and “Strict Exclusion” Ticked.

Section Access;

LOAD * Inline [

ACCESS, USERID, PASSWORD, LINK

ADMIN, ADAM, ADAM, *

USER, PETER, PETER, WALLMART

];

Section Application;

Provider:

LOAD * Inline [

LINK

JCPENNEY

WALLMART ];

[settu_periasamy]

Hi avinashelite,

May be a typo, should be STAR is *;  instead of START is *;

I tested this script. But it doesn't display 2 Link values for User ADAM.

[avinashelite]

Thanks settu_periasamy‌ its a type error from my end 

[avinashelite]

settu_periasamy‌

If * is not giving the right results try with the blank that should

something like

Section Access;

LOAD * Inline [

ACCESS, USERID, PASSWORD, LINK

ADMIN, ADAM, ADAM,

USER, PETER, PETER, WALLMART

];

Section Application;

Provider:

LOAD * Inline [

LINK

JCPENNEY

WALLMART ];

[Colin-Albert]

The star in section access means "all values listed in the section access table" not "all values in the data".

Have a look here for some examples on using section accessQlikView Section Access Examples

[Peter_Cammaert]

The star character in a link field in the Section Access table means: all values that appear in this field in the Section Access table only. NOT all values that appear in identically named fields in your entire data model.

There is no real wildcard-like "every value" concept in the associative data model. You'll have to create it yourself by entering an artificial value in this SA field (like "ALL") and mapping this value to all loaded field values by way of a new Section Application table.

Peter

[Peter_Cammaert]

Note that leaving the link field blank will only lead to showing all values for users with ACCESS=ADMIN (developers) in QV Desktop or QVB.exe. NOT in the AccessPoint where everyone is a USER anyway.