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: 
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