Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Column level secuirty in Qlik Sense

Hi All,

I would like to have a column level security in Qlik Sense something like:

Column level access using Section Access

It is great if we can do below in Qlik Sense!

A - Can see all the columns

B - Can see Sno column

C - Can see name column

D - Can see sno, name and dob columns

Is it possible to do the same thing in Qlik Sense?

Many Thx!!!

Best Regards,

Louis

4 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

the example below will prevent a user from seeing the columns in charts

but if he creates his own visualizations he will be able to see the data

in my experience in qlik sense when we want column security

we use OMIT in the section access which exclude the field completely from the user data

Managing security with section access ‒ Qlik Sense

Anonymous
Not applicable
Author

Hi Liron,

Thx for reply!

If i omit the column let say column A

and one of table contains column A, B,C,

then the table will show an error incomplete visualization.

Is it possible to just blank all value in column A?

Best Regards,

Louis

lironbaram
Partner - Master III
Partner - Master III

hi

i don't think you can blank the values

you might succeed with a work around that assigns a flag to the users you want to see blank values

and then referance this flag in your expression

but to maintain your security across the app , you'll need to prevent those user from doing self-service

work 

catalystmichael
Partner - Contributor III
Partner - Contributor III

I recently discussed this issue on my blog and suggested some workarounds.  Hope it helps:

https://adventuresinqlik.com/2018/03/11/the-problem-with-section-access-in-sense-with-workarounds/