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



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




      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!