Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
brijeshvma
Partner - Creator
Partner - Creator

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

Hi All,

Can Any One Suggest me on My Query

erjohnso
Creator
Creator

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

Re: Section Access: What is the issue?

MK9885
Master II
Master II

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.