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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Nolan
Contributor III
Contributor III

Section Access link table

Good Afternoon,

 

I am trying to execute a very simple Section Access on an app and am running into the problem below:

I am able to limit my view down to one WhN #. So if I assign myself (ngavin) the KEY of '2' in the section access table and then load the app, I am only able to see data relative to WhN 513. However when I try to apply the KEY of '1' to myself to be able to see data from all WhN's the app creates an actual value in the field WhN of '*'

Wondering how to apply the * to include all values instead of creating it's own, thanks!

Nolan_1-1653592388755.png

 

Nolan_2-1653592541396.png

 

Labels (1)
1 Reply
Raja2022
Contributor III
Contributor III

One way of doing the way you want is as below:

section Access;
access:
LOAD * Inline [
ACCESS, USERID, KEY
USER,NGAVIN,*
USER,SYUAN,2
ADMIN,SCHEDULER,1
DUMMY,DUMMY,3
];

Section Application;

DataReduction:
Load * Inline [
KEY, WhN
1,500
2,513
3,514
];

Output:

Raja2022_0-1653612959306.png

 

Hope this helps...