This content has been marked as final. Show 2 replies
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.