Discussion board where members can get started with Qlik Sense.
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?
Go to Solution.
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".
For Calculated measure is formula (if Measure1>0, Measure3/Measure1-1, 1)
(this is formula for Calculated measure, Mesaure1>0)
It is working, thank you.
I was trying that before, but separetly. First I made
and it was not working.
But together works!! Thank you.