hide rows where measures don't have results.

[Florian01]

Hello everyone,

i saw similar questions in this forum but did not find any suitable solution in my case.

I have the table below in qlik sense. I wouls like to not show the row for which measure 2 and 3 are equal to "-".

Is it something possible and if yes with which formula? 

I think it there could be also a solution by showing only distinct numbers in the "numer column" but this seems more complex to me.

Thanks in advance!

Best,

Florian

Date	Number	Measure 1	Measure 2	Truck type	measure 3
09.01.2024	24403051	0.001	10	Truck A	20,00
10.01.2024	24403051	0.001	-	Truck A	-
09.01.2024	24403052	0.002	10	Truck A	20,00
10.01.2024	24403332	0.001	10	Truck B	20,00
11.01.2024	24403332	0.035	-	Truck B	-

[Parthiban]

Hi,

You can try if condition in Date column. 

ex : =if([Measure 2]>0 or [measure 3]>0, Date)

[Or]

Typically the easiest way to handle this is to hide zero/null rows using the standard setting, and modifying Measure 1 so it returns no value in cases where Measure 2 and Measure 3 are both null, e.g.

If(IsNull(Measure2) and IsNull(Measure3),null(),Measure1)

[Florian01]

Thanks for the replies! I will try it.

May be a very easy question but assuming the name of my column is "Measure 1" how can I use this measure in a formula knowing that I do not have this measure as master element?

[Or]

You would have to either spell out the formula used for the measure, or use e.g. Column(1) to reference it. I recommend the former, though, as column references can easily get screwed up when you edit objects.

[Florian01]

ok thanks

[Florian01]

So now all three measures are equal "-" in the same row but the solution with the Date does not work because it can't stay a dimension with the if check. It has to be a measure and then it is also equal to "-" on the same row as the other measure but do lead to the suppression of those rows.

[Florian01]

I did this, now all 3 measures are equal to null in the same rows but it didn't hide those rows unfortunately

[Florian01]

This is only possible in a measure and not in a dimension anymore. If I do thise the date will also be equal to null on the same row as the other measures but it does not hide those rows.

[Florian01 · Accepted solution]

I solved it thanks to this post: 

Solved: Hiding Null values from measures - Qlik Community - 1430786

Very simple solution but very hidden --> Add-Ons --> hide null value.