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

    populate flag based on date and product

    Himadri Laha

      Hi,

      I need to achieve the below scenario in qlik:

       

      IDPRODUCTDATEFLAG
      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 ?