Hide dimension row if key figure is NULL()

[AndreSchwarze]

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?

[theoat · Accepted solution]

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]

That works thank you a lot!

[Velvet_Crowe · Accepted solution]

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>).