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: 
Not applicable

Qlikview - text object num

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?

1 Solution

Accepted Solutions
sunny_talwar

May be like this:

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

View solution in original post

3 Replies
sunny_talwar

May be like this:

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

Not applicable
Author

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?