Need help to limit the line in combo chart till the data exists

[praveensprabhu]

Hi everyone,

I have a combo chart in qlikview, where the line is is flattening and continuing across the weeks even after there is no data for further weeks. This line value is cumulative because of which it is extending across. I need to limit this cumulative value till the week where data is available. 

If you see in the above chart the lines are extending till week 52 even though there is no data. Could someone help me how to limit this?

This is the formula i am using =Rangesum(Above(sum({<FOR.FQ=>}FOR.QTY_ISSUED+FOR.AA_ISSUE),0,RowNo()))/Rangesum(Above(sum({<FOR.FQ=>}FOR.QTY_PER_ASSEMBLY),0,RowNo()))

Request everyone to help me provide the solution.

[edwin]

can you attach a qvw?

[edwin]

look at this one, it might help:
Running totals per dimension (RangeSum(), sortable... - Qlik Community - 1487351