topic Re: Expression Total incorrect for calculated expression in QlikView

Expression Total incorrect for calculated expression

qlikmpate0 — Wed, 05 Aug 2015 09:19:10 GMT

Hi i have a calculated expression which is show an incorrect expression total, please can someone advise, I think its because my expressions is a division but not sure.

thanks in advance

regards

Mina

Re: Expression Total incorrect for calculated expression

sunny_talwar — Wed, 05 Aug 2015 09:23:33 GMT

Try this may be:

=Sum(Aggr(If([POLOC Bi Annual] <= 'Jan-Jun', Sum([PO Amount ($)]), 0), YourDimensions))

Re: Expression Total incorrect for calculated expression

qlikmpate0 — Wed, 05 Aug 2015 09:38:24 GMT

Thanks Sunny.

Re: Expression Total incorrect for calculated expression

sunny_talwar — Wed, 05 Aug 2015 09:39:46 GMT

Not a problem.

I am glad I was able to help.

Best,

Sunny

Re: Expression Total incorrect for calculated expression

Kushal_Chawda — Wed, 05 Aug 2015 09:46:43 GMT

what are the values in field [POLOC Bi Annual] ? how you are doing numerical operation (<=) with string?

Re: Expression Total incorrect for calculated expression

qlikmpate0 — Wed, 05 Aug 2015 10:29:52 GMT

The values are 'Jan-Jun' and 'Jul-Dec'

Re: Expression Total incorrect for calculated expression

qlikmpate0 — Wed, 05 Aug 2015 10:57:28 GMT

The month has a number associated with it hence if its less than or equal to 6 it will have a value of Jan-Jun, otherwise it will be Jul-Dec, hope that helps