Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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...