if statement in expression

stevietm — Fri, 05 Aug 2011 07:48:01 GMT

Hi All

I need to work out an expression with the if statement I have checked the QV help and this is what I got so far if(SEPExcl <'100',’sum((Quantity)/Size) * SEPExcl * 26/100)’,’sum((Quantity)/Size)*Percentage)’)

Every Time when I calculate this it returns the “sum((Quantity)/Size) * SEPExcl * 26/100)” expression and not the value can anyone please help??

Kind Regards Stevie

if statement in expression

SunilChauhan — Fri, 05 Aug 2011 07:49:48 GMT

if(SEPExcl <100,sum((Quantity)/Size) * SEPExcl * 26/100),sum((Quantity)/Size)*Percentage)))

topic if statement in expression in QlikView

if statement in expression

if statement in expression