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



      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.