topic In range syntax in QlikView

In range syntax

cbushey1 — Fri, 28 Nov 2014 16:19:48 GMT

I am looking to create an if statement that is based on a field having a range of possible values.

Example:

In SQL, you would write:

If fieldA in ["value1","value2"...] Then

....

How can I translate this into QV syntax?

Thanks,

fernando_tonial — Fri, 28 Nov 2014 16:25:26 GMT

Hi, use the funciotion Match()

If(Match(Field,'value1','value2',....), Value True, Value False)

Best Regards.

Tonial.

Anonymous — Fri, 28 Nov 2014 16:25:35 GMT

Have a look at the QlikView Match() or WildMatch() functions.

cbushey1 — Fri, 28 Nov 2014 16:32:03 GMT

Is there a way to do this using a range instead of typing all values?

Take the following:

001-015

Instead of typing each possible value out, could I enter a range into the Match function?

maxgro — Fri, 28 Nov 2014 18:18:42 GMT

you can't use a range in match function, you have to type all values

in wildmatch you can use wildcard (* ?)

or for range you can use a sql like syntax also in Qlik load

where field1 >= '009' and field1 <= '021';

Anonymous — Tue, 01 Nov 2016 19:15:24 GMT

Something like this should work:

Pick(Match(Round(FieldA,015),0,15,30,45,60,75,90,105),'A','B','C','D','E','F','G','H')

If you have trouble with it I'd convert your field to a number.