Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

brijeshma
Contributor

Section Access With "Strict Exclusion"

HI All ,

I need Some clarification on Qliksense Section access.

1: Can w use NTNAME in qliksense like Qlikview.

2. Say i have 2 User as USER1 and USER2 . I want to give access to USER2 for country US and FOR USER1 for ALL Countries.

as when USER2 is logging he is able access US that is Happening. But when USER1 is accessing to view all countried , he cant.

means he is nt able to access any thing. As i come to know that we cant  disable "Strict Exclusion". It is always on.

BUT WHEN I AM MENTIONING USER1 ACCESS as ADMIN , HE CAN ABLE TO ACCESS ALL 3 COUNTRIES. So is it correct way of doing. or any other way of doing.

SECTION ACCESS;
LOAD * INLINE [
    ACCESS, USERID,   REDUCTION 
    USER, DOMAIN\USER1,  
    USER, DOMAIN \USER2,1  
];

SECTION APPLICATION;


LOAD * INLINE [
    REDUCTION,  COUNTRY_CODE
    1 , US

    2 , IN

    3 , UK
];

Kindly Help me on the same

3 Replies
brijeshma
Contributor

Re: Section Access With "Strict Exclusion"

Hi All,

Can Any One Suggest me on My Query

erjohnso
Contributor

Re: Section Access With "Strict Exclusion"

See this... sounds like a check box might do the trick:

Re: Section Access: What is the issue?

arvind654
Honored Contributor II

Re: Section Access With "Strict Exclusion"

Star is *;

SECTION ACCESS;
LOAD * INLINE [
    ACCESS, USERID,   REDUCTION , COUNTRY_CODE
    USER, DOMAIN\USER1,  , *

USER, DOMAIN\USER3,  , US

USER, DOMAIN\USER3,  , UK

USER,DOMAIN\USER3, ,IN
    USER, DOMAIN \USER2,1 

USER, INTERNAL\SA_SCHEDULER
];

SECTION APPLICATION;

LOAD * INLINE [
    REDUCTION,  COUNTRY_CODE
    1 , US

    2 , IN

    3 , UK
];


As you left the field blank for USER1 and Section Access doesn't know which field to show....one of the users should have full values or you should place your Inline load inside Section Application Script.


And you need USER, INTERNAL\SA_SCHEDULER to run it in QMC or the load will fail.