Section Access not making a selection

[kev6brown]

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

[Lech_Miszkiewicz]

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

[Fabiano_Martino_Intelco · Accepted solution]

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_Properti...

Regards

Fabiano

[kev6brown]

Tables weren’t linking, working now, thanks