topic Section Access not making a selection in QlikView

Section Access not making a selection

kev6brown — Thu, 16 May 2024 09:45:19 GMT

Hi,

I've added section access to my dashboard and only want to show certain fields for certain people. For example, I want to show UK, USA and Australia for myself. When opening the dashboard the only 3 Areas I can see are the 3 mentioned in a selection box, however the dashboard is still showing values for all Areas, not just the 3 i have access to. What i mean by that is, for example, UK = £100, USA = £200, Australia = £150. I would expect to see an overall total of £450, however I'm seeing £2500 which is the total of ALL areas. Any help would be great.

Kev

Re: Section Access not making a selection

Lech_Miszkiewicz — Thu, 16 May 2024 10:21:50 GMT

HI @kev6brown

Hard to understand without knowing how you have built your section access. It is possible you have not linked properly your section access with the rest of the data model hence it is not working properly. From your description it is not clear how areas should be linked to fact table which is likely driving your kpi values.

you may want to share screenshots of your data model viewer and your section access script (maybe scrable or blur sensitive data - if any)

cheers

Re: Section Access not making a selection

Fabiano_Martino_Intelco — Thu, 16 May 2024 10:47:53 GMT

Hi @kev6brown ,

a check of the links between the SA table and your data model is in fact a good idea.

Just a quick reminder: check in the Document Properties > Opening the value of the flag "Initial Data Reduction Based on Section Access".

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Document_Properties_Opening.htm

Regards

Fabiano

Re: Section Access not making a selection

kev6brown — Wed, 22 May 2024 08:22:48 GMT

Tables weren’t linking, working now, thanks