Getting Products of customers who purchase only once

[#1]

Hi Qlikview Experts,

           My reqirement  is to select the customers from the databse who purchased only one time by using the following expression i can get the customers who purchse once.

=IF(Count(OrderedCustomers)=1,Sum(NetPrice))

it Display the name of the customers and thier amount of sales exactly. I also want to get the products what they are purchased first when i am adding products as one dimension i took all the customers who purchased the products once. Can any one help me..................

[sushil353]

Please post the sample app or data..

[er_mohit]

=IF(Count(OrderedCustomers)=1  and Count(Product)=1 ,Sum(NetPrice))

hope it helps

[#4]

Hi mohit,

Thanks for your reply. The same customer purchased more than one product at a time. When I use your expression, the chart shows no data to display.

[#5]

Hi sushil,

Orderedcustomers is the customerID in the orderes table. I count those customers whose count comes 1 i took the sales of them. I want to get  all the   products that customer purchased is there any possibility

[#6 · Accepted solution]

Hi,

I got the customer sales who have ordered only once and the products they have ordered by using the following expression

     =Sum({<CustomerID={"=Count(DISTINCT OrderID)=1"}>}NetPrice)

Thank you for the support..........

[techvarun]

Helpful! Thanks