topic Mixed Section Access to allow access to summary data and specific data in QlikView

Mixed Section Access to allow access to summary data and specific data

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

Hi.

I have a situation in which we have a summary dashboard with department data and also allows users to see data for specific people. I'd like the users to be able to view the summary data (aggregates of all people's data), but only be able to look at their own specific table. For example, they can view the summary bar charts, but in their name field, only their name should be available. I'm able to limit users access via data reduction based on their NTNAME to their own name field, but of course, the summary data only includes their own.

Re: Mixed Section Access to allow access to summary data and specific data

luismadriz — Tue, 12 Dec 2017 04:18:18 GMT

Hi,

I know I've seen this implemented but with Mashups in QS and with different apps (some with data reduction and some without it) and the mashup controlling what goes where.

But from my experience -which is not much-, it seems you may need to create those summarised tables via the load script so they don't get affected by the data reduction....

I'm keen to see other better options to your post,

Good luck,

Cheers,

Luis

PS. I'm talking from a Qlik Sense perspective... Qlik View may have better ways to do this...

Re: Mixed Section Access to allow access to summary data and specific data

asgardd2 — Tue, 12 Dec 2017 10:38:19 GMT

Hi!

Maybe this will help you and you will be able to more flexibly configure the data provided. (for ex. use all data via set-analysis)

We use alternative metod with triggers.

In our model of data we have additional table USER_NT-USER_REPORT + we create a trigger on open application,which lock field USER_NT.

This trigger have 2 actions:

Select in field - > USER_NT

=If(FieldIndex('USER_NT',Upper(OSUser()))>0,Upper(OSUser()),'Unknown')

Lock field - > USER_NT

So, that the user can not unlock it we create else one trigger on event unlock field,which have one action -> start the macro SetActiveUser:

sub SetActiveUser
vUser =  ActiveDocument.Evaluate("upper(OSUser())")
vUserOK =  CInt(ActiveDocument.Evaluate("FieldIndex('USER_NT','"&vUser&"')"))

set f=ActiveDocument.GetField("USER_NT")
f.Unlock
If vUserOK > 0 then
f.Select vUser
else
f.Select "Unknown"
end if 
f.Lock
end sub

It works only in ajax, there are not button "Clear and unlock all".