topic Re: Hide a Column based on User Access in QlikView

Hide a Column based on User Access

Mon, 26 Jan 2026 18:19:17 GMT

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 Name	Salary show	Salary	Cost Center
aaa	1	877	401
bbc	0	455	501
ccc	1	544	601

Any suggestions?

Thanks in advance.

Re: Hide a Column based on User Access

alexandros17 — Mon, 24 Mar 2014 16:54:53 GMT

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

Re: Hide a Column based on User Access

srchilukoori — Mon, 24 Mar 2014 16:57:45 GMT

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.

Re: Hide a Column based on User Access

maxgro — Mon, 24 Mar 2014 17:02:23 GMT

search for omit in the attachment

Re: Hide a Column based on User Access

Mon, 24 Mar 2014 17:09:41 GMT

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).

Re: Hide a Column based on User Access

Mon, 24 Mar 2014 17:46:01 GMT

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