Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..................
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..........
Please post the sample app or data..
=IF(Count(OrderedCustomers)=1 and Count(Product)=1 ,Sum(NetPrice))
hope it helps
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.
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
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..........
Helpful! Thanks