This content has been marked as final. Show 3 replies
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.
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)