Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
qlikmpate0
Contributor II

Expression Total incorrect for calculated expression

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

Tags (1)
1 Solution

Accepted Solutions

Re: Expression Total incorrect for calculated expression

Try this may be:

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

View solution in original post

6 Replies

Re: Expression Total incorrect for calculated expression

Try this may be:

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

View solution in original post

qlikmpate0
Contributor II

Re: Expression Total incorrect for calculated expression

Thanks Sunny.

Re: Expression Total incorrect for calculated expression

Not a problem.

I am glad I was able to help.

Best,

Sunny

Re: Expression Total incorrect for calculated expression

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

qlikmpate0
Contributor II

Re: Expression Total incorrect for calculated expression

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

qlikmpate0
Contributor II

Re: Expression Total incorrect for calculated expression

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