Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 |
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?
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
Hi,
Take a look at this. Logins are
ADMAN
USER1
USER2
USER3
USER4
Just hit OK on password.
Bill
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?
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