4 Replies Latest reply: Oct 16, 2017 1:07 PM by Shivanand Kamath RSS

    Eliminating specific rows in dashboard

    Rajarshi Guin

      Hi All,

       

      I have a dashboard in the below format.

          

      FirmCases ClosedCases CreatedIn-Progress Cases
      A1000
      B000
      C0200

       

      The column Firm is a dimension while others are measures.

       

      Now the requirement is to show only the firms for which atleast one of the measure is a non-zero value, i.e., the firms for which all the measures are 0 will not be displayed in the dashboard.

       

      So, in this case in the output I should have only the below two rows and not the row for firm B as fro firm B all the measures are 0.

       

          

      FirmCases ClosedCases CreatedIn-Progress Cases
      A1000
      C020

      0

       

      Can anyone please let me know how to implement this in Qlik Sense.

       

      Thanks,

      Rajarshi Guin