topic Set Analysis with count in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-count/m-p/1407838#M426113 <HTML><HEAD></HEAD><BODY><P>I have an expression, =NUM(COUNT(IF(LOCATION = '100 BRIDGE',(TICKET_ID),'#,###.')))</P><P></P><P>I am counting the ticket id, as they are unique values that are 'scanned in' to an event. Counting them gives me a total for attendance. </P><P></P><P>What I want to do is introduce a condition in the equation to count the number of 'Ticket ID' that are scanned at different locations. </P><P></P><P>The expression is constructed correctly and allows me to proceed, however does not produce the intended result. For example, for one event, I have 10,000 scans, 5,000 should be at '100 Bridge' and the other 5,000 should be at '200 Bridge.' Currently my table is just showing the same values for each column.</P><P></P><P>Am I going about this incorrectly?</P></BODY></HTML> Thu, 14 Dec 2017 19:20:27 GMT evansabres 2017-12-14T19:20:27Z Set Analysis with count https://community.qlik.com/t5/QlikView/Set-Analysis-with-count/m-p/1407838#M426113 <HTML><HEAD></HEAD><BODY><P>I have an expression, =NUM(COUNT(IF(LOCATION = '100 BRIDGE',(TICKET_ID),'#,###.')))</P><P></P><P>I am counting the ticket id, as they are unique values that are 'scanned in' to an event. Counting them gives me a total for attendance. </P><P></P><P>What I want to do is introduce a condition in the equation to count the number of 'Ticket ID' that are scanned at different locations. </P><P></P><P>The expression is constructed correctly and allows me to proceed, however does not produce the intended result. For example, for one event, I have 10,000 scans, 5,000 should be at '100 Bridge' and the other 5,000 should be at '200 Bridge.' Currently my table is just showing the same values for each column.</P><P></P><P>Am I going about this incorrectly?</P></BODY></HTML> Thu, 14 Dec 2017 19:20:27 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-count/m-p/1407838#M426113 evansabres 2017-12-14T19:20:27Z Re: Set Analysis with count https://community.qlik.com/t5/QlikView/Set-Analysis-with-count/m-p/1407839#M426114 <HTML><HEAD></HEAD><BODY><P>Not sure I understand, but may be you need this</P><P></P><P><STRONG>=Num(Count({&lt;LOCATION = {'100 BRIDGE'}&gt;} TICKET_ID), '#,###.')</STRONG></P></BODY></HTML> Thu, 14 Dec 2017 19:44:17 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-count/m-p/1407839#M426114 sunny_talwar 2017-12-14T19:44:17Z