# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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.

regards

Mina

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: Expression Total incorrect for calculated expression

Try this may be:

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

6 Replies
MVP

## Re: Expression Total incorrect for calculated expression

Try this may be:

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

Contributor II

Thanks Sunny.

MVP

## Re: Expression Total incorrect for calculated expression

Not a problem.

I am glad I was able to help.

Best,

Sunny

MVP

## Re: Expression Total incorrect for calculated expression

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

Contributor II

## Re: Expression Total incorrect for calculated expression

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

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