topic Re: Split weeks in QlikView

Split weeks

Fri, 12 Sep 2014 16:55:07 GMT

Does anyone have any solutions to fixing split week issues?

I have a table that has forecasts by week..... (i.e 9/1/2014, 9/8/2014..etc) but when the week is 9/29/2014, it only shows forecast for the monday(9/29) and tuesday(9/30).. so the data for wed(10/1),thurs (10/2), and fri (10/3) does not get recorded...

any solution on how to go about this issue?

Re: Split weeks

arniewolff — Fri, 12 Sep 2014 18:02:08 GMT

This sounds like a problem in your selections: if you've got September selected, it would filter out the October dates just as you described. If that's not the case, can you share an example?

Re: Split weeks

Fri, 12 Sep 2014 18:10:07 GMT

But if I want to know how much I made in Week 39 (9/29/14 - Monday date), it should give me the amount that I made that whole week regardless of whether half of it is in September or October... or at least that's how I would like to see it

Re: Split weeks

arniewolff — Fri, 12 Sep 2014 18:14:00 GMT

Does your time dimension include the first few days of October in Week 39? Have you selected both September and October from your months or cleared the months selection?

Re: Split weeks

MarcoWedel — Fri, 12 Sep 2014 18:25:37 GMT

Please post sample data and QVW.

Re: Split weeks

JonnyPoole — Fri, 12 Sep 2014 18:27:54 GMT

i agree its possible and just depends on the data model as well as the context

here is an example whose context depends on whether a monthly context is added to the weekly context

You can see 2 pivot tables below for the same weeks. the first though has month as well. when the week splits from 3/28-> 4/3 , only the march values show because there is a march context. but on the right, the same week includes the values from 4/1 and 4/3 to give a different week total.

Re: Split weeks

ashfaq_haseeb — Sun, 14 Sep 2014 06:06:54 GMT

Hi,

Have a look at this post.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/27/week-numbers#comment-18257

Regards

ASHFAQ