Discussion Board for collaboration on QlikView Scripting.
Wondering if you could help with this. I have a field in a data table that may or may not contain the string "SORD". This could be anywhere in the text string.
What I'd like to be able to do is create a flag (1 or 0) as a new field depending on whether the text string SORD exists in the field. I can do it in Excel but can't get it working in Qlik!
Thanks in advance
Go to Solution.
Try WildMatch() or substringcount(). Check help file for examples.
If(substringcount(Dimension, 'SORD')>0, 1, 0) as Flag
If(WildMatch(Dimension, '*SORD*')>0, 1, 0) as Flag
If(SubStringCount(YourField, 'SORD')>0, 1, 0) as Flag
Marvellous - thanks to both of you that works a treat!
Have a good day.