topic Does "IN" function exists in Qlikview syntax in QlikView

Does "IN" function exists in Qlikview syntax

oxiofrt — Tue, 26 Jan 2010 15:47:09 GMT

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 — Tue, 26 Jan 2010 16:03:49 GMT

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 — Tue, 26 Jan 2010 16:09:24 GMT

Great, thanks a lot for your help !

Anonymous — Tue, 26 Jan 2010 16:18:31 GMT

urw 😉