topic Showing values that excluded due to section access in QlikView

Showing values that excluded due to section access

Rothschild — Fri, 15 Nov 2024 23:49:01 GMT

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

Re: Showing values that excluded due to section access

Chanty4u — Tue, 13 Oct 2020 13:15:22 GMT

have a look on row level security

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

Re: Showing values that excluded due to section access

Brett_Bleess — Tue, 27 Oct 2020 16:19:59 GMT

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#anchor-5

Regards,
Brett

Re: Showing values that excluded due to section access

marcus_sommer — Wed, 28 Oct 2020 15:38:53 GMT

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

- Marcus