Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community,
currently I am working with rangesum to look how my stock is going on.
I use this function :
=Sum(Stock) - RangeSum(above(Aggr(sum("Income/outcome"),material, calender_week),0,RowNo()))
I get for each material the stock for each calender_week.
My Question: How do I get explicit data from the rangesum like:
1. The first calender_week where the stock is less 0
2. The Min or Max value for the stock inside the rangesum
I need the values for each material like:
Material | first calender_week where the stock is less 0
A | Calender_Week 45
B | Calender_Week 35
C | Calender_Week 40
or
Material | Min value for the stock inside the rangesum
A | -50
B | 40
C | 20
I would appreciate any advice
Best regards
Will
Can you share sample data to try with, not sure if you want to use rangemin or rangemax but what chart you want to apply your expression to?
https://community.qlik.com/t5/QlikView-App-Dev/How-to-get-answers-to-your-post/td-p/268841