5 Replies Latest reply: Sep 8, 2017 6:52 AM by Anand Chouhan RSS

    Load script based on condition in Qlik sense

    Raama Kavady

      I have to load data based on condition like

      CUSTOMER     POLICY_NO

      A                       P1

      A                       P2

      B                       P1

      C                       P2

      D                       P1

      D                       P2

       

      If the customer is enrolled to  both P1 and P2 policies, then load only P2.

      Output:

      CUSTOMER     POLICY_NO

      A                       P2

      B                       P1

      C                       P2

      D                       P2