topic Re: Field Filter in App Development

Field Filter

rami_naassaoui — Tue, 03 Mar 2026 14:05:54 GMT

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 ?

Re: Field Filter

Vegar — Tue, 03 Mar 2026 20:23:42 GMT

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.

Re: Field Filter

Chanty4u — Wed, 04 Mar 2026 14:15:01 GMT

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