Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jasmina_karcic
Contributor II

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
agigliotti
Honored Contributor II

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

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
jasmina_karcic
Contributor II

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

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


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

agigliotti
Honored Contributor II

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

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".

jasmina_karcic
Contributor II

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

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

Community Browser