topic Re: Can we do column level access control in qlikview charts ? in App Development

Can we do column level access control in qlikview charts ?

SRT10 — Fri, 03 Dec 2021 12:13:04 GMT

Our dashboard has charts on which revenue is displayed.

Can we have access control for this chart where we need to show column A to one user and rest for everyone.

But how ? Do we have suitable examples

Re: Can we do column level access control in qlikview charts ?

abhijitnalekar — Fri, 03 Dec 2021 13:32:39 GMT

Hi @SRT10 ,

Do you want to remove the particular column from a chart or from full data?

If this is chart specific then you can handle this using show hide functionality or

you can omit the specific column using Section access.

Re: Can we do column level access control in qlikview charts ?

SRT10 — Fri, 03 Dec 2021 18:47:14 GMT

There is a chart of income and it has 5 columns.

I am suppose to have access to all these columns.

But when Abhijit is accessing dashboard he is allowed to see only 4 columns from that chart.

Here we are imposing control for that one particular column based on user list

Re: Can we do column level access control in qlikview charts ?

abhijitnalekar — Sat, 04 Dec 2021 15:50:51 GMT

Hi @SRT10,

I get your point. you can achieve this using column-level section access, where you can omit the specific column for the user. for reference please go through with the below link.

https://www.youtube.com/watch?v=AhgIp5xA_nc

Re: Can we do column level access control in qlikview charts ?

PrashantSangle — Sun, 05 Dec 2021 07:24:22 GMT

I think you want to hide 5th column from specific user. Omit will reduce data from all dashboard. So omit won't work for you

in qliksense,

select chart > properties > expand expression > you will see box for show column if >

over there mention condition for user

like if(wildmatch(osuser(),'SRT10'),1,0)

Regards,

Prashant Sangle