analyze rangesum values

[William2]

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

[Digvijay_Singh]

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