topic Re: Case Count Error in QlikView https://community.qlik.com/t5/QlikView/Case-Count-Error/m-p/1020129#M934352 <HTML><HEAD></HEAD><BODY><P>Thank you!!&nbsp; Worked perfectly!!&nbsp; Now I understand what I did wrong!</P></BODY></HTML> Wed, 24 Feb 2016 19:18:43 GMT gfisch13 2016-02-24T19:18:43Z Case Count Error https://community.qlik.com/t5/QlikView/Case-Count-Error/m-p/1020127#M934350 <HTML><HEAD></HEAD><BODY><P>Hi Everyone - I've got an issue with the pivot table below when trying to calculate the total number of cases and the total number of 'open' cases.&nbsp; As you can see in the screen shot I have the proper values for the total number of cases.&nbsp; MY issue is with counting the 'OPEN' cases.&nbsp;&nbsp; Can someone tell me what I'm doing wrong in this formula, or if there is a better method to use??&nbsp; Thanks!!</P><P></P><P>IF(CASE_STATUS='Open',Aggr(DISTINCT, CASE_NUMBER))</P></BODY></HTML> Wed, 24 Feb 2016 18:09:16 GMT https://community.qlik.com/t5/QlikView/Case-Count-Error/m-p/1020127#M934350 gfisch13 2016-02-24T18:09:16Z Re: Case Count Error https://community.qlik.com/t5/QlikView/Case-Count-Error/m-p/1020128#M934351 <HTML><HEAD></HEAD><BODY><P>Try this for open cases:</P><P></P><P><STRONG>Count(<SPAN style="color: #ff0000;">DISTINCT</SPAN> {&lt;CASE_STATUS = {'Open'}&gt;}CASE_NUMBER)</STRONG></P><P></P><P>UPDATE: forgot to add the DISTINCT</P></BODY></HTML> Wed, 24 Feb 2016 18:53:27 GMT https://community.qlik.com/t5/QlikView/Case-Count-Error/m-p/1020128#M934351 sunny_talwar 2016-02-24T18:53:27Z Re: Case Count Error https://community.qlik.com/t5/QlikView/Case-Count-Error/m-p/1020129#M934352 <HTML><HEAD></HEAD><BODY><P>Thank you!!&nbsp; Worked perfectly!!&nbsp; Now I understand what I did wrong!</P></BODY></HTML> Wed, 24 Feb 2016 19:18:43 GMT https://community.qlik.com/t5/QlikView/Case-Count-Error/m-p/1020129#M934352 gfisch13 2016-02-24T19:18:43Z