3 Replies Latest reply: Dec 23, 2016 2:32 AM by Pavan Vanguri RSS

    how check if text does not Contains & Contains

    Dipesh Vadgama

      Dear All,

       

      I am trying to do script calculation in Qlik Sense. I am trying to find if Fields contains & does not contains particular word in a field.

       

      Eg

       

      Field_name

      Hyd

      Hyd

      Hyd,Sec,Hyd-Sec

      E-Hyd,Sec

      E-Hyd,Old

      Sec,Hyd

       

       

      count(if(field contains "Hyd"and not contains "E-Hyd",1,0) as Countvalue

       

      So I should get a output value = 4 (which contains Hyd but not E-Hyd)