3 Replies Latest reply: Jun 29, 2018 2:53 AM by Jasmina Karčić RSS

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

    Jasmina Karčić

      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,