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: 
slondono
Partner - Creator II
Partner - Creator II

Excel issue - Qlik Sense - Section Access

Hi guys

I have a Section Access script wich works perfectly from an INLINE, this is the script:

LOAD * INLINE [

ACCESS, USERID, Year

ADMIN, domain\user1, 2015

];

(User1 only can see 2015 information)

BUT when i load the data from excel doesnt get access to me.

This is what im doing and what im trying:

s1.PNG

Trying this to:

s2.PNG

and this...

s3.PNG

But the result is always the same: "Access denied". Its wierd because is already working with an inline. What do  i miss??

10 Replies
Gysbert_Wassenaar

Does your inline load also have the Year field completely in upper case, i.e YEAR instead of Year?

Does your Excel file contains upper case values like ADMIN and USER instead of Admin and User?


talk is cheap, supply exceeds demand
rittermd
Master
Master

I think that you need to add

Where 1=1 to your from statement for this to work with section access

slondono
Partner - Creator II
Partner - Creator II
Author

- Year, but is working...also works with YEAR.

- Yes it does

slondono
Partner - Creator II
Partner - Creator II
Author

Doesn´t work with that, still "access denied"

rittermd
Master
Master

This is what I am doing in my app.  I am loading from a QVD instead of Excel and it work fine.

Section Access;

// *************************************************************

// Load QVD file created by Security Extract Task.  This updates nightly

// *************************************************************

LOAD

    "ACCESS",

    "USERID",

    CUSTOMERID

FROM [lib://QVD Files $(vEnvironment)/Healthmax/USERAUTHORIZATION.QVD](qvd)

Where 1=1;

shwetagupta
Partner - Creator II
Partner - Creator II

Hi

As i have mentioned in the previous thread as well you need to specify which field you are refering from your database will come under Section application which will pick data from resident table/load data from database. That is how i worked with excel.

My data is reduced  in the desired way.

slondono
Partner - Creator II
Partner - Creator II
Author

I have a question.

Can i have 2 section access in one app?? One for groups and other for user? Something like this.

Section access;

Load * inline[

Access, userid

ADMIN, user1

];

Section Application;

Section Access;

Load * inline[

Access, group

];

Section Application;

Ricardo_Gerhard
Employee
Employee

Dear Segbastian,

   Try to create the same app like this help.

http://help.qlik.com/en-US/sense/2.2/Subsystems/Hub/Content/Scripting/Security/manage-security-with-...

   PS: on Qlik Sense, the section access works fine after aplication published. I recommend close the browser and open a private mode to reproduce the access.

Regards

Ricardo Gerhard
OEM Solution Architect
LATAM
slondono
Partner - Creator II
Partner - Creator II
Author

Hi Ricardo.

I´ve already saw the guide, but dont explain how to create the groups? are AD groups? so doesnt need domain? And the guide doesnt answer my questions.

regards