topic Re: Next 10 weeks in QlikView

Next 10 weeks

dseelam — Thu, 15 Dec 2016 21:42:24 GMT

Hello All,

I don't know where to start, new requirement asking to create a bucket for next 10 weeks depending on order date, lets say every week starts with Monday and ends with Sunday

So I need to calculate sum(order quantity) for next 10 weeks

Is this possible in scripting itself so that I can create filed as weeks from Week 1 to Week 10 as values ?

Thanks in advance,

Dinesh

Re: Next 10 weeks

neelamsaroha157 — Thu, 15 Dec 2016 22:06:18 GMT

May be you can use

Sum({$<={">$(=WeekStart(max(Date)))<$(=WeekStart(max(Date)+70))"}>}Orders)

You can tweek it if you want Weekend.

Re: Next 10 weeks

dseelam — Mon, 19 Dec 2016 13:47:19 GMT

Hello Neelam,

I am not calculating as an expression, I need it to be working on whole data model!

Thanks