2 Replies Latest reply: Mar 10, 2017 12:58 AM by Jayaseelan K RSS

    How to find returning customers, lost customers, new customers

    Akanksha Potdar

      Hi,

       

      I am trying to build table with new, returning, lost customers.

       

      Data is of last 3 years-2015,2016,2017

      New Customer - Customer in 2017 only

      Returning customer- Was customer in 2015, not n 2016, again customer in 2017

      lost customer: was customer in 2015/2016 , not customer in 2017

       

      I have fields : Customer-name, Year, Bookings.

       

      I have seen blog posts how to do this in qlikview, but I am not sure how will this achieved in qliksense.

       

      Thanks,

      Akanksha