Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I got 2 tables in qlikView
one table contains the following columns and sample data:
Brand Store
ADL 1
DIS 1
DIS 2
YTR 2
YTR 3
...
Now I want to get table for security with users and what each user is allowed to see
the security table contains as structure and sample data the following:
USER Store Brand
U1 * ADL
U2 1 *
U3 * *
U4 2 YTR
can someone give me the best practive for implementing the security here
Hi Ali
Try with this:
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
USER, U1, pwd
USER, U2, pwd
USER, U3, pwd
USER, U4, pwd
ADMIN, su, su
];
Section Application;
Star Is *;
Users:
LOAD * INLINE [
USERID, Store, Brand
U1, *, ADL
U2, 1, *
U3, *, *
U4, 2, YTR
];
Star Is;
oneTable1:
LOAD * INLINE [
Brand
ADL
DIS
YTR
];
oneTable2:
LOAD * INLINE [
Store
1
2
3
];
Note that I had to use two tables in the application I could not get it to work when I had one table like this:
oneTable:
LOAD * INLINE [
Brand, Store
ADL, 1
DIS, 1
DIS, 2
YTR, 2
YTR, 3
];
don't know why...
hth anyway/gg
however to avoid synthetic keys I need that the second scenario works