topic Re: Column level secuirty in Qlik Sense in Management & Governance

Column level secuirty in Qlik Sense

Anonymous — Thu, 24 Nov 2016 02:40:21 GMT

Hi All,

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

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

lironbaram — Thu, 24 Nov 2016 03:40:50 GMT

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

Anonymous — Thu, 24 Nov 2016 04:24:30 GMT

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 — Thu, 24 Nov 2016 06:06:12 GMT

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 — Mon, 12 Mar 2018 12:56:49 GMT

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