Does "IN" function exists in Qlikview syntax

[oxiofrt]

Hi,
in a calculated dimension of a chart, I would like to simplify my syntax :

if(dimension = 1 or dimension =2 or dimension = 5 or dimension = 12, dimension)

Aimed syntax would look like if(dimension in(1,2,5,12), dimension)

Is it possible ? and how ?

Thanks a lot for your help

[Anonymous · Accepted solution]

Hi, oxioFRT,

For such purposes in QlikView I use Match (or Mixmatch) function.

In your case it will look like If(Match(dimension,1,2,5,12)>0, dimension).

In case you need to exclude some values, the script will be If(Match(dimension,1,2,3,12)=0,dimension)

Match function is case sensitive while Mixmatch isn't

Rgds,
Artjoms

[oxiofrt]

Great, thanks a lot for your help !

[Anonymous]

urw 😉