Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to calculate Rangesum for above 12 rows only in Script?

Hi,

I need to calculate the RangeSum of Current month with above 12 month,

like this I need to calculate it for every month,

I'm having a table like this

Capture1.JPG

and I need answers in this way,

Capture2.JPG

11 Replies
Anonymous
Not applicable
Author

Thanks Mate ,

I've deleted this extra field in the code (Peek(Value,-12))

and It works fine.

Thanks for your Time.

jyothish8807
Master II
Master II

You are welcome. you can close the thread if you have got the answer

Best Regards,
KC