Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a QV model with list of main keys.
The SA that allows only one value, even when the user has permission to see more than one.
ex: I have keys 1111, 2222, 3333, 4444
sa:
ACCESS, USERID, NTNAME, KEY
ADMIN, 1111 , A1, 1111
ADMIN, 2222, A1, 2222
So, when A1 wants to open the model, he inserts userid &password (1111,1111) and he sees only 1111 although he has permission to se 2222 also.
Now, I have list of regular values too:
1111 - 'aaaa'
2222 - 'bbbb'.
I want that when user will open 1111, whe would show LB with 'aaaa' possible, and 'bbbb' impossible.
I hope thatw's clear.
Thanks!!
have a look on row level security
https://community.qlik.com/t5/New-to-QlikView/Row-Level-Security-in-Qlikview/m-p/1370266
See the following Design Blog post:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766
There are other links to related posts at the bottom of the post, just FYI, be sure to look over the reduction ones. The other thing may be the following Help Doc link, look at the OMIT feature there:
Regards,
Brett
Just remove USERID from the SA. It's not really needed if you used NTNAME for the authentication.
- Marcus