Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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?

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Qlikview - text object num

May be like this:

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

3 Replies
MVP
MVP

Re: Qlikview - text object num

May be like this:

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

Not applicable

Re: Qlikview - text object num

instead 5000 i got 4973, what can be problem

MVP
MVP

Re: Qlikview - text object num

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