topic Re: hide rows where measures don't have results. in App Development

hide rows where measures don't have results.

Florian01 — Thu, 01 Aug 2024 10:17:24 GMT

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	-

Re: hide rows where measures don't have results.

Parthiban — Thu, 01 Aug 2024 10:32:41 GMT

Hi,

You can try if condition in Date column.

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

Re: hide rows where measures don't have results.

Or — Thu, 01 Aug 2024 10:32:54 GMT

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)

Re: hide rows where measures don't have results.

Florian01 — Thu, 01 Aug 2024 11:27:15 GMT

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?

Re: hide rows where measures don't have results.

Or — Thu, 01 Aug 2024 11:31:28 GMT

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.

Re: hide rows where measures don't have results.

Florian01 — Thu, 01 Aug 2024 11:35:45 GMT

ok thanks

Re: hide rows where measures don't have results.

Florian01 — Thu, 01 Aug 2024 13:36:06 GMT

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.

Re: hide rows where measures don't have results.

Florian01 — Thu, 01 Aug 2024 13:50:43 GMT

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

Re: hide rows where measures don't have results.

Florian01 — Thu, 01 Aug 2024 13:51:56 GMT

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.

Re: hide rows where measures don't have results.

Florian01 — Thu, 01 Aug 2024 14:05:43 GMT

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.

Re: hide rows where measures don't have results.

Or — Thu, 01 Aug 2024 14:10:27 GMT

Was in my original post... 🙂

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

Re: hide rows where measures don't have results.

Florian01 — Thu, 01 Aug 2024 15:09:17 GMT

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