2 Replies Latest reply: Jan 5, 2018 11:32 AM by Allu Allu RSS

    populate flag based on date and product

    Himadri Laha


      I need to achieve the below scenario in qlik:


      123A1st Jan 2018New
      123A2nd Jan 2018Existing
      123A3rd Jan 2018Existing
      123B4th Jan 2018New



      For the above scenario , I need to populate the FLAG as 'New' or 'Existing' .

      If for an ID product name is same but the DATE is different then earliest date data flag should be set as New, afterwards data will be flagged as Existing , but if the product name changed for the same ID , then that record should be flagged as New.


      How to achieve that scenario in qliksense ?