topic Re: Detailed dimension or total based on user in QlikView

Detailed dimension or total based on user

curiousfellow — Thu, 10 Dec 2020 10:03:04 GMT

In my authorisation-table some people are authorized for the same dimension.

I want to show detailed dimension based on username, otherwise the dimensions should be presented with the text "Total not authorized".

In included qvw details are shown for the selected user, however the line "Total not authorized" include some values which are in the detailed information too, because an other user is authorized to some same dimensions. So the sum of the rules is not equal to the grand total.

How to prevent that the the detailed records are not included in the "Total not authorized" line

Re: Detailed dimension or total based on user

edwin — Tue, 15 Dec 2020 20:10:55 GMT

Look at Henric's blog on section access re detailed and aggregated data - which sounds like what you need

Data Reduction – Yes, but How? - Qlik Community - 1463051

Re: Detailed dimension or total based on user

curiousfellow — Thu, 17 Dec 2020 09:01:08 GMT

Allthough Henric advices to use two seperate applications it seems to be possible to use Aggregation-level access .

I have to investigate how to use that, was not aware of that possiblility.

Re: Detailed dimension or total based on user

edwin — Thu, 17 Dec 2020 11:47:35 GMT

at the end of the day, what you really need is just association between your user's IDs and the specific rows you want them to access. now if you have a fact with concatenated detail and aggregations there should be a way to associate the IDs to the rows you want them to have:

USERID1 - Detail1
USERID2 - Detail2
USERID3 - Detail3
USERID1 - AGGR OF Detail1 and Detail2
USERID2 - AGGR OF Detail1 and Detail2
USERID3 - AGGR of Detail3

this means each user can only see their individual details, but Users 1 and 2 share the same AGGR and user3 has exclusive on AGGR3.

this will not work if your AGGR is in a separate table and your section access is linked only to the detail table.

it will work if your detail and AGGR are concatenated into one fact table or the detail and aggr tables are linked and your section access is on the link table.