Discussion Board for collaboration on QlikView Scripting.
Hopefully someone can help and highlight what I am doing wrong.
Attached is a very simple file using section access, and I am trying to set U1 (User 1) has admin rights and can see all and U2 (User 2) can only see part of the the data as a user.
However when I log in as U2 I get access denied (I am assuming it is because there are no matches as it allows access when strict Exclusion is unticked ?)
Log in as U1 to see script, and can anyone see what I have done wrong ?
I am sure it is something obvious but I am struggling to see it
Go to Solution.
Problem is in Capitalization (Upper Case) of the section access field. Try like:
LOAD * INLINE [ ACCESS, USERID, COMPANY_ID ADMIN, U1, Comp1 ADMIN, U1, Comp2 ADMIN, U1, Comp3 ADMIN, U1, Comp7 USER, U2, COMP1 USER, U2, COMP2];
Company_Data:LOAD * INLINE [ COMPANY_ID, COMPANY_ NAME COMP2, Company1 COMP2, Company2 Comp3, Company3 Comp7, Company7];
After user login QlikView will attempt to copy the selections in
fields in section access to any fields in section application with exactly the same field names (the field
names must be written in UPPER CASE)
Hence, ideally you should load your Section Application data using Upper() like:
Upper(COMPANY_ID) as COMPANY_ID,
Company_Data:LOAD * INLINE [ COMPANY_ID, COMPANY_ NAME Comp1, Company1 Comp2, Company2 Comp3, Company3 Comp7, Company7];
Please see the attachment, this appliaction will help you to build Section Access concept. Below are the credentials to open the application.
see the attched file
take user ID as urs.....U1,U2
hope this helps
Thank you tresesco
Worked a treat - However slightly strange why it needs to be upper case - but it is what it is ..... working now
QV reads Section Access data as UPPER CASE, hence to match the same you have to convert the Application data as UPPER to match.