topic Re: Error of Using Count in the Expression in QlikView https://community.qlik.com/t5/QlikView/Error-of-Using-Count-in-the-Expression/m-p/394438#M484493 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use IF Statement.</P><P></P><P>If(Count(OrderedCustomers)=1,Sum(NetPrice))</P><P></P><P>Thanks</P></BODY></HTML> Wed, 22 May 2013 08:06:16 GMT 2013-05-22T08:06:16Z Error of Using Count in the Expression https://community.qlik.com/t5/QlikView/Error-of-Using-Count-in-the-Expression/m-p/394437#M484492 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> I Want to get the customers details who purchased only once.All details about the customer purchase in orders table i took the customerID from orders table as OrderedCustomers. To find the customers&nbsp; and amount of purchase who purchase only one&nbsp; time i use the following expression </P><P></P><P></P><P></P><P></P><P>=Sum({&lt;Count(OrderedCustomers)={1}&gt;}NetPrice)</P><P></P><P></P><P></P><P></P><P></P><P> But it shows Error can any one help how to get the customers purchase only onetime.(Net price is the amount where UnitPrice * Quantity - Discount )</P></BODY></HTML> Wed, 22 May 2013 07:08:46 GMT https://community.qlik.com/t5/QlikView/Error-of-Using-Count-in-the-Expression/m-p/394437#M484492 2013-05-22T07:08:46Z Re: Error of Using Count in the Expression https://community.qlik.com/t5/QlikView/Error-of-Using-Count-in-the-Expression/m-p/394438#M484493 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use IF Statement.</P><P></P><P>If(Count(OrderedCustomers)=1,Sum(NetPrice))</P><P></P><P>Thanks</P></BODY></HTML> Wed, 22 May 2013 08:06:16 GMT https://community.qlik.com/t5/QlikView/Error-of-Using-Count-in-the-Expression/m-p/394438#M484493 2013-05-22T08:06:16Z Re: Error of Using Count in the Expression https://community.qlik.com/t5/QlikView/Error-of-Using-Count-in-the-Expression/m-p/394439#M484494 <HTML><HEAD></HEAD><BODY><P>Thankyou <SPAN class="replyToName" style="font-size: 14px;">umeshjadhav</SPAN> </P></BODY></HTML> Wed, 22 May 2013 09:12:01 GMT https://community.qlik.com/t5/QlikView/Error-of-Using-Count-in-the-Expression/m-p/394439#M484494 2013-05-22T09:12:01Z