Section Application with wildcard?

Mon, 24 May 2010 16:24:31 GMT

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>

topic Section Application with wildcard? in QlikView

Section Application with wildcard?