topic Expression Error in QlikView

Expression Error

Mon, 27 Oct 2014 05:16:59 GMT

Dear All,

Please help me to find the error in following expression.

ROUND(ONLY(IF(SUB='FIN',GRO_PRE*.01)={"<0"},SUM(IF(SUB='FIN',GRO_PRE*.01))))

Regards,

Priyantha.

Re: Expression Error

PrashantSangle — Mon, 27 Oct 2014 05:28:05 GMT

Hi,

Try like this

ROUND(ONLY(IF(SUB='FIN',GRO_PRE*.01)<0,SUM(IF(SUB='FIN',GRO_PRE*.01))))

Regards

Re: Expression Error

anbu1984 — Mon, 27 Oct 2014 05:28:06 GMT

ROUND(ONLY(SUM(IF(SUB='FIN' And GRO_PRE*.01 <0,GRO_PRE*.01))))

Re: Expression Error

tresB — Mon, 27 Oct 2014 05:29:47 GMT

It seems that the expression could be optimized. However, that would require more information like, where you are using this expression(chart/text box/..), what you expect the output to be...Otherwise, syntactically if you want the correction, it might be like:

ROUND(ONLY(IF(SUB='FIN',GRO_PRE*.01)<0,SUM(IF(SUB='FIN',GRO_PRE*.01))))

Re: Expression Error

suresh_rawat — Mon, 27 Oct 2014 05:36:09 GMT

Hi,

Use This :

ROUND(ONLY(IF(SUB='FIN',GRO_PRE*.01)<=0,SUM(IF(SUB='FIN',GRO_PRE*.01))))

Regards

Suresh Rawat