9 Replies Latest reply: Jun 25, 2018 9:45 AM by Anil Samineni RSS

    Sub String

    rajesh Gurram

      Hi All Please need help on below requirement in Qlik Sense

       

       

      DataSale
      (HH) ajshjklagdhh
      (HP)kjhkjhghjghjghp2
      (HH)gfghfgd
      (HP)fdghdghdhgdg4
      (HH)gjgjhjhjhhj
      (HP)fdgdgggfggfg6
      (HP)adsgfdghdgdg7

       

      Out put

       

       

      DataSaleForOUT PUT
      (HH) ajshjklagdhh(HH)2
      (HP)kjhkjhghjghjghp2(HP)0
      (HH)gfghfgd(HH)4
      (HP)fdghdghdhgdg4(HP)0
      (HH)gjgjhjhjhhj(HH)13
      (HP)fdgdgggfggfg6(HP)0
      (HP)adsgfdghdgdg7(HP)0