Discussion board where members can learn more about Qlik Sense App Development and Usage.
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:
Thanks in advance,
May be this:
Sum(Aggr(FirstSortedValue(DISTINCT Aggr(sum(QTY), IDPROD,DATEINV) , -DATEINV), WARH, IDPROD, DayInv))