Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Need Help in scripting(Calculating 13 Weeks Sellout)

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

3 Replies
Not applicable

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

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

Not applicable

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

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

Not applicable

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

Hello All,

Please need Help...

Thanks & Regards,

Venkat t

Community Browser