topic Re: Dynamically chart visible to users(grooup) in QlikView

Dynamically chart visible to users(grooup)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a small doubt,suppose if we have more than 100 charts in dashboard it is difficult to declare like below

ChartAccess:

LOAD * INLINE [

USERID, CH01, CH02

A,1,1

B,1,0

C,0,1

D,1,1];

Is there any alternative way to achieve this dynamically and also suppose if we want to assign to particular chart particular group . What would be the solution.

Can anyone explain or send me sample app

Thanks.

Re: Dynamic chart visible to users(grooup)

Peter_Cammaert — Tue, 15 Mar 2016 15:44:06 GMT

Replace the USERID field in ChartAccess by a GROUPID field. Every GROUPID comes with a distinct object access mask. You'll need fewer entries in this ChartAccess table, I guess.

Now decide on how many different groups you need (not every user has a different usage pattern), and assign each user to a specific GROUPID.

Peter

Re: Dynamic chart visible to users(grooup)

Anonymous — Tue, 15 Mar 2016 15:51:47 GMT

Hi Peter,

Thanks for ur reply.

If I have minimum 20 groupID and 66 charts. In that do we need to mention all charts and groupID's in the same pattern as we mentioned in earlier.

Regards,

Kumar

Re: Dynamic chart visible to users(grooup)

Peter_Cammaert — Tue, 15 Mar 2016 15:59:58 GMT

Well, you will have to enter at least 20 GroupID lines in your ChartAccess table.

But the 66 columns can be replaced with a 66 character string consisting of 1's and 0's that indicate the visibility of a particular object. This only works if all of your "switchable" objects have successive object IDs.

Or even better, you can replace the 66 columns with a text string that lists enabled Object IDs, If your users on average have access to only a reduced range of objects, this type of ChartAccess table might be more efficient to manage:

ChartAccess:

GroupID, ObjectList

GROUP01, CH01;CH02;CH03

GROUP02, CH10;CH20;CH30;CH40;CH50

GROUP03, CH50;CH51;CH52;CH53

A Wildmatch(ObjectList, 'CHxx') in every Object Conditional Show will do the trick.

You should perform an analysis of users & object access rights first. How many objects do your users need access to on average?

Peter

Re: Dynamic chart visible to users(grooup)

Anonymous — Tue, 15 Mar 2016 16:31:10 GMT

Some users(super users) want to see almost all objects. This is where my problem occurring.

Re: Dynamically chart visible to users(grooup)

Peter_Cammaert — Thu, 17 Mar 2016 07:42:30 GMT

You can add a second column in your ChartAccess table with chart symbols to deny access to. For example, if a user should be allowed access to all objects except four on a sheet with employee information, put those four symbols in the second column.

Still, you should first perform an analysis of users & object access rights first. How many objects do your users need access to on average?

Peter

Re: Dynamically chart visible to users(grooup)

Peter_Cammaert — Thu, 17 Mar 2016 07:44:45 GMT

Another possible improvement for permission manageability may be to store all groups and access rights in an Excel file, and load your ChartAccess table content from there. May prove easier to work with.

Peter