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:

        

      MarketingChannelsJan16Feb16Mar16Apr16
      Channel118310786810
      Channel2846401,2291,040
      Channel3520350

      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,

      Samuel