Qlikview - text object num

[#1]

I have text object with text

    =num( Sum( Aggr( Quantity*Price, PostingYear1, sPosting Date] )), '#,##0.0')

and I have year 2015 and 2016.

When save this expresions i got sum of bouth year 2015 and 2016. how to get only 2015?

[sunny_talwar · Accepted solution]

May be like this:

=Num(Sum({<Year = {2015}>} Aggr(Only({<Year = {2015}>} Quantity*Price), PostingYear1, sPosting Date])), '#,##0.0')

[#3]

instead 5000 i got 4973, what can be problem

[sunny_talwar]

Very difficult to say by just looking at the numbers. Would you be able to share a sample?