Documents for QlikView related information.
Please find attached Qlikview document for implementing chart level access by user. You can open the Qlikview file by using users A, B, C and D. There is no Password for this file.
When you login as user A you can access both charts (CH01 and CH02).
When you login as user B you can access only one chart (CH01).
When you login as user C you can access only one chart (CH02).
When you login as user D you can access both charts (CH01 and CH02).
This is implemented by using Chart Properties -> Layout -> Show -> Conditional.
The charts and users are configured using ChartAccessMatrix table. Refer below script for implementation.
LOAD * INLINE [
USERID, CH01, CH02
Due to license problem,i cant open your qvw.could you please post a screenshot of the condition used in the chart?
I did like this
=Sum(CH01) > 0
Thank you jagan. Its working great..
HELLO JAGAN, I WRITE MY SECTION ACCESS LIKE THIS.
LOAD * Inline [
WHAT IS THAT 1,1 AND 1,0 PLS EXPLAIN ME JAGAN AND WHICH PLACE I GIVE CONDITION AND HOW TO WRITE CONDITION.PLS TELL ME OUT JAGAN .
1 Means user have access to the chart, 0 means it won't show the chart.
Thanks for sharing valuable information. Here I have one doubt, suppose if we have more than 100 charts in dashboard it is difficult to declare like below what you mentioned in your post.
Is there any alternative way to achieve this and also suppose if we want to assign to particular group to particular chart. What would be the solution.
Map users to groups and assign chart access to groups instead of users.
Hi I went through all types of access level section as well as sheet and chart. I did not understand which one should i use. I want a particular user to see some apps and he should not be able top edit the script or view any of the tables.
This logic works only if the "Initial data reduction based os section access" option is checked.
In my report if I check that option, no one can access the report from access point including me.
However I am able to open in my local machine. What could be the issue?