topic Customer with One event count per channel in App Development https://community.qlik.com/t5/App-Development/Customer-with-One-event-count-per-channel/m-p/1601431#M44515 <P>Hi All,</P><P>I have a data set containing&nbsp; resembling below table.</P><TABLE><TBODY><TR><TD>Channel</TD><TD>Event</TD><TD>Cust</TD></TR><TR><TD>1</TD><TD>X</TD><TD>A</TD></TR><TR><TD>1</TD><TD>X</TD><TD>B</TD></TR><TR><TD>1</TD><TD>Y</TD><TD>C</TD></TR><TR><TD>1</TD><TD>Z</TD><TD>D</TD></TR><TR><TD>1</TD><TD>Q</TD><TD>A</TD></TR><TR><TD>2</TD><TD>Z</TD><TD>A</TD></TR><TR><TD>3</TD><TD>Z</TD><TD>B</TD></TR><TR><TD>4</TD><TD>X</TD><TD>D</TD></TR><TR><TD>1</TD><TD>W</TD><TD>E</TD></TR></TBODY></TABLE><P>The requirement is to get the count of customers having only one event per channel.</P><P>for example, here for channel1 ,we have 4 Customers having only one event( B,C ,D,E). so the count is 4.</P><P>I have to apply the logic for large data set to get this output.</P><P>waiting for your responses.</P> Thu, 11 Jul 2019 13:50:41 GMT Sujayrsp 2019-07-11T13:50:41Z Customer with One event count per channel https://community.qlik.com/t5/App-Development/Customer-with-One-event-count-per-channel/m-p/1601431#M44515 <P>Hi All,</P><P>I have a data set containing&nbsp; resembling below table.</P><TABLE><TBODY><TR><TD>Channel</TD><TD>Event</TD><TD>Cust</TD></TR><TR><TD>1</TD><TD>X</TD><TD>A</TD></TR><TR><TD>1</TD><TD>X</TD><TD>B</TD></TR><TR><TD>1</TD><TD>Y</TD><TD>C</TD></TR><TR><TD>1</TD><TD>Z</TD><TD>D</TD></TR><TR><TD>1</TD><TD>Q</TD><TD>A</TD></TR><TR><TD>2</TD><TD>Z</TD><TD>A</TD></TR><TR><TD>3</TD><TD>Z</TD><TD>B</TD></TR><TR><TD>4</TD><TD>X</TD><TD>D</TD></TR><TR><TD>1</TD><TD>W</TD><TD>E</TD></TR></TBODY></TABLE><P>The requirement is to get the count of customers having only one event per channel.</P><P>for example, here for channel1 ,we have 4 Customers having only one event( B,C ,D,E). so the count is 4.</P><P>I have to apply the logic for large data set to get this output.</P><P>waiting for your responses.</P> Thu, 11 Jul 2019 13:50:41 GMT https://community.qlik.com/t5/App-Development/Customer-with-One-event-count-per-channel/m-p/1601431#M44515 Sujayrsp 2019-07-11T13:50:41Z