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?

[anat]

use show column if condition

[AndreSchwarze]

I´m not looking for "column" I´m looking for "row".
What would be applicable to that?

[theoat]

Go to complement, data manipulation and don't include null values.

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

[anat]

can you uncheck "include zero values" option

[AndreSchwarze]

Thank you for your answer, but unfortunatly Qlik only gives me the option for that for Dimension A, not for Dimension B.
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.

[AndreSchwarze]

No. This option is not even shown in Qlik:

[AndreSchwarze]

In dimension A it is shown:

[theoat]

Not in the settings of the dimension, but in the settings of the complement --> manipulation of data

look the picture.

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

[AndreSchwarze]

Thank you for that hint, it was lost in translation as "Complement" is translated as "Add-Ons" in my Qlik.
Nevertheless. I unchecked the option, but it is not producing any effect...