Showing values that excluded due to section access

[Rothschild]

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

[Chanty4u]

have a look on row level security

https://community.qlik.com/t5/New-to-QlikView/Row-Level-Security-in-Qlikview/m-p/1370266

[Brett_Bleess]

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:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Security.htm#an...

Regards,
Brett

[marcus_sommer]

Just remove USERID from the SA. It's not really needed if you used NTNAME for the authentication.

- Marcus