topic Re: Omit and Reduce - Section Access in QlikView

Omit and Reduce - Section Access

rishimessi19 — Sat, 16 Nov 2024 01:48:13 GMT

I have the following Data:

EMP_ID	Salary	Gender
1	100	M
2	200	M
3	300	M
4	400	F

How to achieve the below 2 scenarios using Section access?

Scenario 1

USER1 has access to EMP_ID 1 & 2 and can see both their salaries but only 1's Gender. The resultant table should look like this when USER1 logs in:

EMP_ID	Salary	Gender
1	100	M
2	200

Scenario 2

USER2 cannot see EMP_ID 3's salary . The resultant table should look like this when USER2 logs in:

EMP_ID	Salary	Gender
1	100	M
2	200	M
3		M
4	400	F

Note 1: I tried OMIT, but QlikView Omits the entire column and not partially.

Note 2: The salary and Gender information are in the same table.

Re: Omit and Reduce - Section Access

qliksus — Tue, 03 Dec 2019 05:31:32 GMT

What you are expecting is not reduction its hiding its better to have this defined in the back end instead of doing a conditional based hide in the front end . Maybe , just create a new field called Salary1 ,Gender1 and use that fields in your front end

	EMP_ID	Salary	Gender	Salary1	Gender1
User1	1	100	M	100	M
User1	2	200	M	200
User2	3	300	M		M
User2	4	400	F	400	F
User2	1	100	M	100	M
User2	2	200	M	200	M

Re: Omit and Reduce - Section Access

rishimessi19 — Tue, 03 Dec 2019 14:37:05 GMT

Thanks for the reply. Gender and Salary is just an example I took to describe the requirement.

In the real time scenario I have many fields and many users. Can you provide a better solution for if possible?

Re: Omit and Reduce - Section Access

Bill_Britt — Tue, 03 Dec 2019 20:45:00 GMT

Hi,

Take a look at Section Access 101 PDF I have attached. Also, check out Henric's Blog (link below)

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

Bill

Re: Omit and Reduce - Section Access

Bill_Britt — Tue, 03 Dec 2019 21:22:32 GMT

Hi,

Take a look at this. Logins are

ADMAN

USER1

USER2

USER3

USER4

Just hit OK on password.

Bill

Re: Omit and Reduce - Section Access

rishimessi19 — Wed, 04 Dec 2019 14:56:46 GMT

Hi Bill

Thank you for the reply. But your solution does not meet the requirement.

1. I have only 2 users

2. The Salary and Gender data in your solution does not hide/show as stated in the requirement.

Can you please let me know if you have any other ideas?

Re: Omit and Reduce - Section Access

Brett_Bleess — Wed, 11 Dec 2019 14:11:03 GMT

I would suggest you go through the Design Blog post link Bill attached to the thread and begin there, I am also including the Help link for Section Access too. If you want direct assistance in working out your application, that is really something the consultants would be used to do or one of our many partners would be happy to help you out as well in that case...

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

I believe between the Design Blog post, which has some further links to other related posts in it, and the above Help link, should give you the educational material you need to sort things out.

Regards,
Brett