Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Application with wildcard?

Hi,

Thank you for checking out my post. Can you please help with Section Access/Application?

I am looking to assign Section Application access to NTNAME based on a value in one field.


Section Access;
[ACCESS, NTNAME, DEPT
ADMIN, NTUSER1, Admin,
ADMIN, NTUSER2, Admin, <-- for publisher
USER, NTUSER3, Dept1,
USER, NTUSER4, Dept2,
USER, NTUSER5, Dept3];


Then


Section Application;
start is *;
load * inline
[DEPT, ourdepartment <-- existing column in my load
Admin, *
Dept1, AB <-- 2 letter initials
Dept2, KG,
Dept3, SP
];


Qlikview Table


I have two columns, col1 and col2 (excluding quotes)
01, "AA,AB,CC,DD"
02, "AA,BB,KG.DD,FF,GG,HH,II"
03, "AA,BB,SP.DD,NN,55,RR,YU,RD"
04, "AA,AB,KG,CC,DD,45,13,44"
05, "AA,AB,SP,CC,DD"
06, "AB"
[/CODE]
Is there a way to assign a wildcard to section application so NTUSER3 for DEPT1 (AB) will be able to see row 01, 04, 05 and 06 instead of 06 only? Same logic should applied to NTUSER4 and 5 also.

Thank you very much for your help
</body>
0 Replies