Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

rishimessi19
New Contributor II

Omit and Reduce - Section Access

Hi

I have the following Data:

EMP_IDSalaryGender
1100M
2200M
3300M
4400F

 

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_IDSalaryGender
1100M
2200 

 

Scenario 2

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

EMP_IDSalaryGender
1100M
2200M
3 M
4400F

 

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.

5 Replies
qliksus
Valued Contributor II

Re: Omit and Reduce - Section Access

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_IDSalaryGenderSalary1Gender1
User11100M100 M
User12200M200 
User23300M M
User24400F400F
User21100M100M
User22200M200M
      
      
rishimessi19
New Contributor II

Re: Omit and Reduce - Section Access

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?

Support
Support

Re: Omit and Reduce - Section Access

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 - Designated Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Support
Support

Re: Omit and Reduce - Section Access

Hi,

 

Take a look at this. Logins are

ADMAN

USER1

USER2

USER3

USER4

Just hit OK on password.

 

Bill

Bill - Designated Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
rishimessi19
New Contributor II

Re: Omit and Reduce - Section Access

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?