19 Replies Latest reply: May 17, 2018 12:02 PM by Elizabeth Viso RSS

    Data Containing Anything other than 1 or 0 will not Total

    Elizabeth Viso

      Hello!

       

      I have this data on an excel type sheet that I am pulling into Qlik Sense:

       

      Capture5.16.18.PNG

       

      When I total the amount of "1" it works fine, but when I try and count the "R13" I always get 0 when I should get a total of 31. The expression I am using is the following:

       

      =Count({<EScore= {'R1'}>} EScore)

       

      I'm not really sure what it's not working.

       

      Thank you in advance!