Apply filter to dsiplay Zero rows and empty KPIs !!

[rami_naassaoui]

Hello,

I have a flag field FLAG_EXTERNAL in my fact table that currently contains only the value "No" for all observations (no "Yes" values exist in the data).

Goal: I want to create a button that, when clicked:

1. Selects all values EXCEPT "No" (essentially selecting "Yes" or any non-existent value)
2. Results in zero observations being selected
3. Displays all KPIs as zero/null and shows empty tables
4. Keeps the filter pane visible showing the exclusion of "No"

Important constraint: I cannot modify existing objects (charts, KPIs, tables) - the solution must work through button actions and selections only.

What I've tried:

Attempt 1: Single action with non-existent valueAction:

Select values matching search criteria
Field: FLAG_EXTERNAL
Value: Yes
Result: Nothing happens, no filter is applied, no selection is made

Attempt 2: Two actions - Select then Exclude

Action 1: Select values matching search criteria with value No
Action 2: Select excluded on FLAG_EXTERNAL
Result: The filter appears briefly then immediately disappearsg happens, no filter is applied, no selection is made

Attempt 3: Added "Lock field after selection"

• Checked the "Lock field after selection" option in Actions panel
• Result: Same issue - filter still disappears

Question: How can I create a button action that successfully selects non-existent values (or excludes "No") and maintains the filter selection showing zero observations?

Are there alternative approaches I should consider? I'm using Qlik Sense

Thank you !

[marcus_sommer]

Each selection depends on existing values. NULL isn't a value and couldn't be accessed. Therefore the solution is quite simple: replace all NULL with real values within the data-model, maybe per coalesce(MyField, 'NULL') as MyField.

[Or]

https://community.qlik.com/t5/Data-Movement-Streaming/How-to-exlude-a-certain-value-when-applying-a-...

[rami_naassaoui]

@marcus_sommer I've already shared this in another post. One workaround I found, that finally worked, is to add an observation to the fact table with empty values except for the flag wich has 'Yes' using autogenerate(1).
This way the filter has something to step on and display empty tables and chart 
Cheers !