Hello everybody,
I have the following Data:
![timo_brenner_0-1642494774281.png timo_brenner_0-1642494774281.png](https://community.qlik.com/t5/image/serverpage/image-id/70391iB0B05CE2BB9B182D/image-dimensions/919x159?v=v2)
The Column "voraussichtlich Verfügbar bis Fälligkeit" calculates the stock for each "Komponentennr." until a certain date ("Komponentenfälligkeit"). The Formula is:
[Bestand_Komponentennr.]-
Aggr(rangesum(above( sum(Komponentenrestmenge),0,rowno())),[Komponentennr.],([Komponentenfälligkeit],(Numeric, ascending)))
Now I want to creat a new column which should show the minimum of the calculated stock for each combination of "FA-Nr.", "FA-Zeilennr." and "Arbeitsgangnummer".
In the first five rows the callback has to be 191, in the last three rows it has to be -147.
I tried following formula:
MIN(aggr(
Aggr(rangesum(above( sum(Komponentenrestmenge),0,rowno())),[Komponentennr.],([Komponentenfälligkeit],(Numeric, ascending))),[FA-Nr.],[FA-Zeilennr.],[Arbeitsgangnr.]))
The formula doesn't work. There isn't a result in any row.
What am I doing wrong?
Thanks for your help.
Best regards
Timo Brenner