Null Dimension Values || Hide them or show them dependencies

[jorgie]

Hi to the Q community!

I try to find the solution to the following table.

I want based on metric, to have visible only null value of dimension or to hide it.

I also, when i select value to set filter ie 2020 to keep null value selected (background)

the current form is 

I want to have

thank you all in advance!

[Or]

Have a look at: https://community.qlik.com/t5/Design/NULL-The-Invisible-Nothing/ba-p/1467674

[jorgie]

hi, and thank for taking time to answer.

unfortunatelly this is not my case.

I am looking for something like

if Measure=MetricA then dont display Null in dimensions or If Measure=MetricB display only Null in dimensions

Also, if I select to filter Year values 2023, 2024 to also get by default and the null value in order to show it for the measures I want to

[Or]

As a rule of thumb, you can't really do that (at least, not with any sort of efficiency). You would typically want to write this into your measures, e.g.

If(Measure = MetricA AND NOT IsNull(Dim1),Measure)

And then use Hide zero/null on measures.

[jorgie]

I tried, didnt work as i needed. I have seen it before, when you select dimension analysis in Years, some metrics wich are not time dependent for example are with - value.

The final form is something like that

[Or]

I'm afraid I don't quite understand what it is you're trying to do. Perhaps someone else will be able to help...