Omit and Reduce - Section Access

[rishimessi19]

Hi

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.

[qliksus]

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

[rishimessi19]

Hi 

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?

[Bill_Britt]

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

[Bill_Britt]

Hi,

Take a look at this. Logins are

ADMAN

USER1

USER2

USER3

USER4

Just hit OK on password.

Bill

[rishimessi19]

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?

[Brett_Bleess]

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