Qlik Sense Section Access is not working properly

[venturahl]

Hi to all,

I'm facing a problem with section access that i cannot resolve/ understand

I've two sources of data: DW (sales data) and an excel file (targets). My user QlikAdmin, can see all sales data but the data from excel is not appearing.

In my data model, i had already created an autorization key field to connect to my section access script:

Section Access;

SecurityTable:

LOAD * INLINE [

ACCESS, USERID, YEAR, MONTH, COD_EMPRESA, COD_SA, COD_PROS, COD_TECNICO, AUTHORIZATIONKEY, COD_CLIENT

ADMIN, SRVBIQLIK\QLIKADMIN, *, *, *, *, *, *, *, *

];

Concatenate

Load *

Resident TabSA;

Section Application;

Drop Table TabSA;

So, my user QlikAdmin as an administrator with asterisk in every fields is not able to see all data.

What can i do to solve this problem?

Hope someone can help me soon,

Regards,

Helga

[antoniotiman]

Hi Helga,

Administrator is able to see only fields who Users are seeing , not all data.

Try to remove * from Administrator row (like Null Field).

Regards,

Antonio

[venturahl]

Hi Antonio,

First of all, thanks for you quick answer.

If i do that, administrator is unable to see some fields....

My admin, cannot see only the values that came from an excel sheet. For example: my column COD_TECNICO only have some codes, and the values of this codes i can see withou any problem. When this field had null/empty codes, I as admin, 'i'm not able to see the values of my measure.

Regards,

Helga

[antoniotiman]

Have You tried

ADMIN, SRVBIQLIK\QLIKADMIN, , , , , , ,

[venturahl]

Yes Antonio, unfortunately didn't work.

[antoniotiman]

I'm sorry, I don't know this behavior.

However, I think is not correlated to Section Access.

May be Your Expression.

Regards,

Antonio

[venturahl]

If i comment the section access, the values are correct.

I've a collegue of mine that tells me that section access does not work properly with null values in the columns that we want to restrict some data.

Regards,

helga

[njmaehler]

Hi Helga,

Section Access with the Asterix will work however it only works on the access provided to the other users.

Here is an example:

Section Access;
LOAD * INLINE [
    ACCESS, USERID, PASSWORD, %FLIGHTTYPE
    ADMIN, ADMIN, ADMIN123, *
    USER, DF, DF123, DOMESTIC_FOREIGN
    USER, DU, DU123, DOMESTIC_US
    USER, IF, DIF123, INTERNATIONAL_FOREIGN
];
Section Application;

LOAD * INLINE [
%FLIGHTTYPE, Flight Type
    DOMESTIC_FOREIGN,"Domestic, Foreign Carriers"
    DOMESTIC_US, "Domestic, US Carriers Only"
    INTERNATIONAL_FOREIGN,"International, Foreign Carriers"
    INTERNATIONAL_US,"International, US Carriers Only"
];

Notice that Admin is assigned * to the %FLIGHTTYPE field.

There are 3 other users with the values of DOMESTIC_FOREIGN, DOMESTIC_US and INTERNATIONAL_FOREIGN for the %FLIGHTTYPE field.

Notice in the INLINE table below there are actually 4 different values available for the %FLIGHTTYPE field therefore INTERNATIONAL_US has not been assigned to anyone.

You normally think that the assign * would actually include all 4 different %FLIGHTTYPE values however it does not. The asterix only applies to the 3 that have been assigned to users.

In order to get around this you need to change the access to include an additional line for the Admin user and assign the value of INTERNATIONAL_US to the %FLIGHTTYPE field.

Section Access;
LOAD * INLINE [
    ACCESS, USERID, PASSWORD, %FLIGHTTYPE
    ADMIN, ADMIN, ADMIN123, *
    ADMIN, ADMIN, ADMIN123, INTERNATIONAL_US
    USER, DF, DF123, DOMESTIC_FOREIGN
    USER, DU, DU123, DOMESTIC_US
    USER, IF, DIF123, INTERNATIONAL_FOREIGN
];
Section Application;

LOAD * INLINE [
%FLIGHTTYPE, Flight Type
    DOMESTIC_FOREIGN,"Domestic, Foreign Carriers"
    DOMESTIC_US, "Domestic, US Carriers Only"
    INTERNATIONAL_FOREIGN,"International, Foreign Carriers"
    INTERNATIONAL_US,"International, US Carriers Only"
];

Hope that helps,

Nicky

[venturahl]

Hello Nicky,

thank you very much for the explanation, it was very useful!

Hope this help other people with the same doubts as me

Regards,

Helga