Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
AndreSchwarze
Contributor II
Contributor II

Hide dimension row if key figure is NULL()

Hello dear Qlik community,
I have a table with two dimensions: A (location) & B (month).
Key figures (sales) are assigned to the matrix of A & B.
My goal is to hide rows of dimension B (month) if the key figure is NULL().

Qlik is not giving me the option to exclude NULL-Values for Dimension B, only for Dimension A.

Furthermore there could be the case if the value of dimension A changes, there could be values that are not NULL for rows in dimension B.
Sorry for beeing not that clear in the original question. edited that.

Unfortunately, I have no idea how to solve this.

Maybe someone from the community has a tip for me?

Labels (2)
12 Replies
theoat
Partner - Creator III
Partner - Creator III

If you use TCD
Set one dimension in Line, one in column.
Uncheck the option in the 2 dimensions and in "Add-Ons".

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

AndreSchwarze
Contributor II
Contributor II
Author

That works thank you a lot!

Velvet_Crowe
Contributor III
Contributor III

Hello,

this option only works if the measure is 0 or null. If you want to hide a row based on a dimension value you have to check the dimension ich each measure with e.g. if(IsNull(<DIM B>), Null(), <Calc>).