6 Replies Latest reply: Aug 22, 2013 8:53 AM by Varun Prakash Paulraj RSS

    Getting Products of customers who purchase only once

      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..................