I’m facing an issue when using the Top/Flop function in Qlik Cloud.
In my “Flop Effectif (%)” table, I should see the 7 lowest DOPs, but only 3 are displayed.
It seems that Qlik includes DOPs without data (null or zero values) and places them before the others, which pushes the real values out of the Top/Flop limit (set to 7).
When I disable the “Include zero values” option, only the 3 DOPs with actual data remain visible — even though I should have 7 real results.
You can see this in the screenshot — the color codes show that only the first 3 DOPs with real data appear, while the empty ones take the first positions.
👉Question:
Is there a way to exclude null or empty values from the Top/Flop calculation so that only DOPs with real data are considered in the Top 7?
You’re running into the fact that Top/Flop is calculated before the “Include zero values” display option, so it still counts all those DOPs with null/empty results in the ranking.
A simple way around it is to filter out the empty DOPs in the expression or dimension, e.g.:
If( Not IsNull([Flop Effectif (%)]) and [Flop Effectif (%)] <> 0, [Flop Effectif (%)] )
or use a Show condition / dimension value filter like:
Count({<[Flop Effectif (%)]={">0"}>} DOP) > 0
This way only DOPs with real data are even considered, and your Top 7 will be the 7 lowest non-empty values.
