Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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
MVP
MVP

Re: Problem with Totals using FirstSortedValue and aggr

May be this:

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


Capture.PNG