Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewaf
Creator
Creator

Section Access: ? how to solve it

Hi,

i just implemented Section access as follow

SECTION ACCESS;

LOAD * INLINE [

ACCESS, NTNAME, REGION_DESCRIPTION

USER, EMEA\AZARRA, ITALY

];


the NTNAME is the one coming out from Upper(OSUser()) formula.

Then i flagged the 2 checkbox here.opening.PNG



when i enter the application i'm able to see everything.

There's some step that i'm missing?

Thank you

Labels (1)
25 Replies
YoussefBelloum
Champion
Champion

there is something wrong because with strict exclusion if there is no Italy data, he will see a restriction message..

I'm I wrong ?

qlikviewaf
Creator
Creator
Author

i just used osuser()  to check if domain\user was correct: i'm not using this on the section access.


Of course i have data from italy, in the field "Region_Description" with value "Italy"

qlikviewaf
Creator
Creator
Author

reggggg.PNG

YoussefBelloum
Champion
Champion

do you wrote Section access; and Section Application; like mentioned above ?

qlikviewaf
Creator
Creator
Author

This is exactly what i have on my script

reggggg.PNG

PrashantSangle

If there is no Italy data then user will see all data.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
PrashantSangle

Section access is case sensitive

Italy should be in caps

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
PrashantSangle

Screen shot which you post earlier and above posted data wont match..

here REGION_DESCRIPTION is caps and Value ITALY in caps but

earlier screen shot both are in small letter.

Is there anything which we are missing\??

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
YoussefBelloum
Champion
Champion

If there is no Italy data and there is user who is reduced to Italy, what is the difference between Strict exclusion SA and NOT strict exclusion SA as a result for that user then ?

qlikviewaf
Creator
Creator
Author

Good point - in the data-set the value is "Italy" - is something manageable?

What i have to write then in the Section Access? "Italy" as well? or it's required to have only CAPS value?