Field Filter

[rami_naassaoui]

Hi everyone,

I'm working on a Qlik Sense application and I'm facing an issue with a specific filtering field called "Daprtement"

this field is directely in the fact table STRUCTURE.

it has to show 12 distinct values in the visualisation however, i see only 11 when i put  DEPARTEMENT on a filter.

when i try to test the 

Test_DEPARTEMENT  :
load
distinct DEPARTEMENT  as TEST_DEPARTEMENT
RESIDENT STRUCTURE;

Test_DEPARTEMENT  now contains 12 distinct values. What went wrong ?  it it related to the section access ? 

[Vegar]

It can absolutely be related to your section access configuration. 

How is that setup? Is it on DEPARTEMENT level or other. Note, if you use *, then it does not automatically give you access to all - only the accumulate of all values listed for all the users in the SA.

[Chanty4u]

Hi

If one department has:

No transactions after reduction

Or filtered by selection

Or excluded by Section Access

It will not show in filter pane.

Or try this create a table with

DEPARTEMENT

Count(STRUCTURE_ID).

If it shows 0 then it wil not show in filter