topic Re: Need Help in scripting(Calculating 13 Weeks Sellout) in QlikView

Need Help in scripting(Calculating 13 Weeks Sellout)

Mon, 30 Sep 2013 14:34:34 GMT

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

Re: Need Help in scripting(Calculating 13 Weeks Sellout)

Mon, 30 Sep 2013 15:09:10 GMT

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

Re: Need Help in scripting(Calculating 13 Weeks Sellout)

Tue, 01 Oct 2013 10:16:42 GMT

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

Re: Need Help in scripting(Calculating 13 Weeks Sellout)

Tue, 01 Oct 2013 18:06:26 GMT

Hello All,

Please need Help...

Thanks & Regards,

Venkat t