topic Re: Apply filter to dsiplay Zero rows and empty KPIs !! in Reporting Service & Alerting

Apply filter to dsiplay Zero rows and empty KPIs !!

rami_naassaoui — Tue, 30 Dec 2025 15:02:04 GMT

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:

Selects all values EXCEPT "No" (essentially selecting "Yes" or any non-existent value)
Results in zero observations being selected
Displays all KPIs as zero/null and shows empty tables
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 !

Re: Apply filter to dsiplay Zero rows and empty KPIs !!

marcus_sommer — Mon, 05 Jan 2026 11:51:46 GMT

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.

Re: Apply filter to dsiplay Zero rows and empty KPIs !!

Or — Mon, 05 Jan 2026 12:18:21 GMT

https://community.qlik.com/t5/Data-Movement-Streaming/How-to-exlude-a-certain-value-when-applying-a-filter-with-string/m-p/2540020#M3511

Re: Apply filter to dsiplay Zero rows and empty KPIs !!

rami_naassaoui — Mon, 05 Jan 2026 13:36:08 GMT

@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 !

Re: Apply filter to dsiplay Zero rows and empty KPIs !!

Chanty4u — Mon, 12 Jan 2026 16:47:56 GMT

Try this

FACT:

LOAD

Field1,

Field2,

FLAG_EXTERNAL

FROM Source;

CONCATENATE (FACT)

LOAD

NULL() AS Field1,

NULL() AS Field2,

'Yes' AS FLAG_EXTERNAL

AUTOGENERATE 1;