topic Error in expression:If takes 2-3 parameters in QlikView

Error in expression:If takes 2-3 parameters

Mon, 01 Oct 2012 11:34:41 GMT

Good morning,

I'm trying to make a sentence LOAD...FROM...WHERE conditional, the script should load some rows according to an if condition. I think I wrote the condition correctly nevertheless It gives me the error message "Error in expression:If takes 2-3 parameters". Could anybody tell me the reason?.

FROM

\\Qlikview\Pruebas\PROY_PRODUCCIONES\HISPRODUCCIONES.QVD (qvd)WHERE FECRSA<(TODAY()-366) AND
IF(num(MONTH(Today())>10,
FECHA>=MONTHSTART(Today()-366) AND FECHA<=monthend('01/'&TEXT(NUM(month(today()))-10)&'/'&Year(today())),
FECHA>=MONTHSTART(Today()-366) AND FECHA<=monthend('01/'&TEXT(NUM(month(today()))+2)&'/'&Year(today()-366))));

Thanks.

Re: Error in expression:If takes 2-3 parameters

swuehl — Mon, 01 Oct 2012 11:40:00 GMT

Your condition

num(MONTH(Today())>10

lacks a closing bracket.

I don't know what you want to do with your then / else branches, but I assume there are probably additional if() statements missing.

Re: Error in expression:If takes 2-3 parameters

Mon, 01 Oct 2012 11:47:38 GMT

I've revised the 'then' and 'else' sentences for hours and I did not revise condition.

Thank you very much.