Announcements
cancel
Showing results for
Did you mean:
Creator III

## How to hide row in table that contains all zero values in measures?

Hi everyone,

I have an issue in Qlik Sense, that I cannot solve.

In one table I have for example:

For Calculated measure is formula (if Measure>0, Measure3/Measure1-1, 1)

Name            Measure1  Measure2  Measure3 ....  Calculated_measure

Elma              35                44              0                        -1

Jasmina          44                56              73                      73/44 -1

Aida                0                  0                0                        1

Lejla                0                  3                5                        1

I don't want to show Aida row, because all measure (1,2,3) contain 0 values. But because of rule (if Measure>0, Measure3/Measure1-1, 1) in a Calculated measure I got 1.

I cannot implement in Add-on unchecking "Include zero values".

Is there any other solution? How can I hide all rows where are measures 0?

Thank you,

Jasmina

1 Solution

Accepted Solutions
Partner - Champion

for your calculated measure you can use the below expression:

if( column(1) = 0 and column(2) = 0 and column(3) = 0, 0,

if( Measure1>0, Measure3/Measure1-1, 1)

)

finally untick "Include zero values".

3 Replies
Creator III
Author

For Calculated measure is formula (if Measure1>0, Measure3/Measure1-1, 1)

(this is formula for Calculated measure, Mesaure1>0)

Partner - Champion

for your calculated measure you can use the below expression:

if( column(1) = 0 and column(2) = 0 and column(3) = 0, 0,

if( Measure1>0, Measure3/Measure1-1, 1)

)

finally untick "Include zero values".

Creator III
Author

Great!!!

It is working, thank you.

I was trying that before, but separetly. First I made

if( column(1) = 0 and column(2) = 0 and column(3) = 0, 0,

if( Measure1>0, Measure3/Measure1-1, 1)

)

and it was not working.

But together works!! Thank you.

Jasmina