topic Expression problem with 'If' condition in QlikView

Expression problem with 'If' condition

Wed, 13 May 2015 06:45:22 GMT

Hi Everyone,

I am facing problem to write simple expression in qlikview with 'If Condition'.

Fist expression is fine bt second expression partial sum total is wrong.

I marked with red color.

And I am attaching the excel file and qv application also.

Please give me a solution. Thanks in advance

mohammadkhatimi — Wed, 13 May 2015 06:57:37 GMT

Hie..

EXPRESSION:-

sum(aggr(If(Sum(Value)>0,Sum(Value),0),Country,MonthNo))

PFA.

Regards,

Mohammad

danieloberbilli — Wed, 13 May 2015 07:00:03 GMT

use this expression:

sum(aggr(If(Sum(Value)>0,Sum(Value),0),Country,MonthNo))

Wed, 13 May 2015 07:07:16 GMT

Hi,

Try out below expression. it should work.

=sum(If((Value)>0,(Value),0))

Regards,

Raksha