Discussion Board for collaboration related to QlikView App Development.
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
Try this may be:
=Sum(Aggr(If([POLOC Bi Annual] <= 'Jan-Jun', Sum([PO Amount ($)]), 0), YourDimensions))
View solution in original post
Not a problem.
I am glad I was able to help.
what are the values in field [POLOC Bi Annual] ? how you are doing numerical operation (<=) with string?
The values are 'Jan-Jun' and 'Jul-Dec'
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