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

Problem with Totals using FirstSortedValue and aggr

Hi Gurus,

I'm trying to create a pivot table: Dimensions: WARH (warehouse), IDPROD, (product) and DATEINV (date inventory) , period (master dimension year, month, day).

Expression, Stock at the end of Year, Month, Day: FirstSortedValue(DISTINCT Aggr(sum(QTY), IDPROD,DATEINV) , -DATEINV)

Details are OK but the total is not correct:

Year

CaseFirstSortedMonth.jpg

Month

CaseFirstSortedYear.jpg

Day

CaseFirstSortedDay.jpg

Thanks in advance,

Juan

1 Reply
sunny_talwar

May be this:

Sum(Aggr(FirstSortedValue(DISTINCT Aggr(sum(QTY), IDPROD,DATEINV) , -DATEINV), WARH, IDPROD, DayInv))


Capture.PNG