2 Replies Latest reply: Aug 22, 2016 11:38 AM by Haritej Kambhampati RSS

    Total shows '0' for Conditional Counting in Qlik Sense Chart

    Haritej Kambhampati

      Hello Guys,

       

      I am trying to achieve conditional counting by comparing two measures A and B and count only when A>B. I was able to achieve this by a simple expression in chart measure

      if(A>[B], count(A), 0).

      The problem is with the Total in the Chart (Which I cannot remove in Qlik Sense) shows '0' for that measure. Please find the screen cap for the reference. Let me know if I am missing something. Thanks for your help.

      Conditional Counting.PNG