Announcements
cancel
Showing results for
Did you mean:
Contributor III

## hide rows where measures don't have results.

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.

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 -
Labels (1)
• ### General Question

1 Solution

Accepted Solutions
Contributor III
Author

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.

11 Replies
Creator

Hi,

You can try if condition in Date column.

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

MVP

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)

Contributor III
Author

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?

MVP

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.

Contributor III
Author

ok thanks

Contributor III
Author

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.

Contributor III
Author

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

Contributor III
Author

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.

Contributor III
Author

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.