Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Not applicable

Hide a Column based on User Access

Can we hide a column based on user Access/Windows AD?


For e.g: I have the below column. My section access will be on Cost Center field. Also, I would like to hide the column Salary where Salary Show = 1. So, only 'bbc' would see the salary details.

employee NameSalary showSalaryCost Center
aaa1877401
bbc0455501
ccc1544601

Any suggestions?

Thanks in advance.

1 Solution

Accepted Solutions
Not applicable

Re: Hide a Column based on User Access

If the Secction Access table is linked to the table you describe by the employee Name, when you access the application there should be just one [Salary show] value. For this to work the Secction Access table must have the [employee Name] field in order to link tables.

If that is so, then if salary is treated as a dimension, check the option to hide it on conditional when [Salary show]=0. If you are treating it as an expression, then show on conditional [Salary show] = 1 (on the expressions tab of the properties menú of the object).

5 Replies

Re: Hide a Column based on User Access

In expression use conditional check box and test osuser() with the user you want to exclude

srchilukoori
Valued Contributor

Re: Hide a Column based on User Access

If you are using the section access, add the field name in the Hide condition on the presentation tab. This will automatically hide a chart when the user's Show Salary value = 0.

MVP
MVP

Re: Hide a Column based on User Access

search for omit in the attachment

Not applicable

Re: Hide a Column based on User Access

If the Secction Access table is linked to the table you describe by the employee Name, when you access the application there should be just one [Salary show] value. For this to work the Secction Access table must have the [employee Name] field in order to link tables.

If that is so, then if salary is treated as a dimension, check the option to hide it on conditional when [Salary show]=0. If you are treating it as an expression, then show on conditional [Salary show] = 1 (on the expressions tab of the properties menú of the object).

Not applicable

Re: Hide a Column based on User Access

Thanks everyone. It worked. I used show condition in expression while using section access on Cost Center.

Community Browser