Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
venturahl
Partner - Contributor III
Partner - Contributor III

Qlik Sense Section Access is not working properly

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

8 Replies
antoniotiman
Master III
Master III

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
Partner - Contributor III
Partner - Contributor III
Author

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
Master III
Master III

Have You tried

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

venturahl
Partner - Contributor III
Partner - Contributor III
Author

Yes Antonio, unfortunately didn't work.

antoniotiman
Master III
Master III

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
Partner - Contributor III
Partner - Contributor III
Author

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
Partner - Creator
Partner - Creator

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
Partner - Contributor III
Partner - Contributor III
Author

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