Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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 

Highlighted
Partner
Partner

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/