9 Replies Latest reply: Dec 1, 2015 10:18 AM by Chris Whiteley RSS

    Qlik Sense Count IF & Gauge Question

      Hi All,

       

      I'm new to Qlik so apologies if this is a silly question.

      I currently have a table that contains a column which is the difference between the 2 preceeding columns:

       

      ID    |     A    |    B    |    B-A

      102  |    10    |    10   |    0

      103  |    10    |    5     |    5

       

      I'm trying to implement a gauge which shows the percentage of records in this table where the final column = 0 but am struggling with the expression to calculate this. I should also mention that columns A and B are SUM functions based on the ID dimension.

       

      Thanks in advance,

      Chris