topic Re: conditional if statement? in QlikView

conditional if statement?

Thu, 30 Jul 2015 11:36:47 GMT

Hi all,

How to represent the multiple values for a filed in the if condition:

PLT IN ( 'ANMF','Partenon','UFSS' )

COD2 IN ( '1006' )

if(COD2='1006' AND PLT =( 'ANMF','Partenon','UFSS' )

Iam using if condition as the conditional dimension for the bar chart. I tried with different options but not succeed.

Your help is greatly appreciated..

Regards

Siva

Anonymous — Thu, 30 Jul 2015 11:41:25 GMT

try this

=if((COD2='1006') AND (match(PLT,'ANMF','Partenon','UFSS' )>0)

Ralf-Narfeldt — Thu, 30 Jul 2015 11:43:42 GMT

if(COD2='1006' AND match(PLT, 'ANMF','Partenon','UFSS' ))

PrashantSangle — Thu, 30 Jul 2015 11:43:55 GMT

Hi,

You can use match() or wildmatch() or mixMatch()

For details go and check it in Help menu.

Regards

sasiparupudi1 — Thu, 30 Jul 2015 11:52:57 GMT

if((match(COD2,'1006')>0 AND match(PLT, 'ANMF','Partenon','UFSS')>0),'True','False')

Thu, 30 Jul 2015 12:08:28 GMT

Try like this

if(COD2='1006' AND (PLT = 'ANMF' OR PLT='Partenon' OR PLT='UFSS' ),..........)

jonathandienst — Thu, 30 Jul 2015 12:27:20 GMT

If this is for an aggregation function like Sum or Count, rather use set analysis:

Sum({<COD2 = {1006}, PLT = {'ANMF', 'Partenon', 'UFSS'}>} Value)

This will perform better than Sum(If())....

Thu, 30 Jul 2015 12:50:35 GMT

Thanks for all your replies...

is this same for not equal sign? I mean for " not maching"

For ex:

ID= '01'

AND NOT(GRU='30390000' AND CON='A90' AND VAL IN ('IN1','IN2')))"

Regards

Siva