topic Re: Create a Flag Based on a Text String in QlikView

Create a Flag Based on a Text String

stuwannop — Tue, 22 Oct 2013 07:24:11 GMT

Hi Everyone

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

Stu

Re: Create a Flag Based on a Text String

jagan — Tue, 22 Oct 2013 07:28:28 GMT

Hi,

Try WildMatch() or substringcount(). Check help file for examples.

LOAD

If(substringcount(Dimension, 'SORD')>0, 1, 0) as Flag

FROM DataSource;

LOAD

If(WildMatch(Dimension, '*SORD*')>0, 1, 0) as Flag

FROM DataSource;

Regadrs,

Jagan.

Re: Create a Flag Based on a Text String

tresB — Tue, 22 Oct 2013 07:28:55 GMT

Try like:

If(SubStringCount(YourField, 'SORD')>0, 1, 0) as Flag

Re: Create a Flag Based on a Text String

stuwannop — Tue, 22 Oct 2013 07:45:02 GMT

Marvellous - thanks to both of you that works a treat!

Have a good day.

Stu