5 Replies Latest reply: Jan 27, 2017 1:32 PM by David Rudolph RSS

    set analysis inner select of a group

    Samuel Lin

      Hi Qlikers,


      I am thinking this is impossible, but just want to be sure.


      I have a table in Qlik like this:



      for first measurement column, the formula is:


      count({<[FirstOrderDate]={'>=01/01/2016<=01/31/2016'}, [order date]={'>=01/01/2016<=01/31/2016'}>} distinct MasterContactID)


      and got: a count of 18


      What I hope to achieve is to isolate these 18 people, and track their revenue from the month they joined 01/01/2016 to present, any idea how this can be done?


      say in the data structure there exists: "Revenue" column associated with [order date]


      Many thanks,