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	-

[Or]

Was in my original post... 🙂

"Typically the easiest way to handle this is to hide zero/null rows using the standard setting"

[Florian01]

oh sorry I didn't new this option and I thought you meant the checkbox available for dimensions