Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
SRT10
Contributor III
Contributor III

Can we do column level access control in qlikview charts ?

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

 

QlikView 

4 Replies
abhijitnalekar
Specialist II
Specialist II

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. 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
SRT10
Contributor III
Contributor III
Author

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

abhijitnalekar
Specialist II
Specialist II

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

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
PrashantSangle

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 > 

PrashantSangle_0-1638688977967.png

over there mention condition for user

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

 

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂