Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmpate0
Creator II
Creator 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

1 Solution

Accepted Solutions
sunny_talwar

Try this may be:

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

View solution in original post

6 Replies
sunny_talwar

Try this may be:

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

qlikmpate0
Creator II
Creator II
Author

Thanks Sunny.

sunny_talwar

Not a problem.

I am glad I was able to help.

Best,

Sunny

Kushal_Chawda

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

qlikmpate0
Creator II
Creator II
Author

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

qlikmpate0
Creator II
Creator II
Author

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