Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Need help in calculating the cumulative sum of Prev13 weeks including current week, and we need to have this values next to each Week in the data..and this has to be done at script level.
Looking forward for your help.
Thanks & Regards,
Venkat T
Hi,
I would suggest you to read the document I have written a few time ago:
http://community.qlik.com/docs/DOC-4821
It explains, in the script, how to populate an Asof table, which will be used to do the rolling cumultative datas, the YTD etc. it should answer to your question.
Fabrice
Hello Fabrice,
Thanks for your reply, but i want some thing like below.
say we have 30 weeks data , from 13th week we should sum up the Previous data(EX: 13th week 1-13 , 14th week 2-14 15th week 3-15..and so on). hope you understand my requirement. and i need to this in LOAD Script level not in report level.
Thanks & Regards,
Venkat T
Hello All,
Please need Help...
Thanks & Regards,
Venkat t