topic Re: Week number issue when week start made to Sunday in QlikView

Week number issue when week start made to Sunday

apoorvasd — Mon, 03 Jul 2017 09:43:31 GMT

Hello everyone,

I have tried changing week start to Sunday using this code: WeekStart(Datefield, 0, -1) as WeekStart and this works as expected. When I choose a particular week number, it displays dates starting from Sunday of that week until Saturday which is fine. But the problem is, when I choose the last week (say, week 53) in a particular year (say, 2015) I don't see all 7 dates, as few dates would belong to next year. I would like to include these dates also into previous week. How can this be achieved?

Attached in my example, When I choose, week 53 of 2015, would like to include 1st and 2nd Jan of 2016 too.

Thank you.

Re: Week number issue when week start made to Sunday

Anonymous — Mon, 03 Jul 2017 09:46:23 GMT

did you try weekyear(date) for your year field?!?

Re: Week number issue when week start made to Sunday

MK_QSL — Mon, 03 Jul 2017 09:52:16 GMT

Check WeekYear function

Re: Week number issue when week start made to Sunday

MK_QSL — Mon, 03 Jul 2017 09:53:21 GMT

Week(DateField) & '-' & WeekYear(DateField) as WeekYear

Re: Week number issue when week start made to Sunday

apoorvasd — Mon, 03 Jul 2017 10:03:03 GMT

Thanks for the response.

I just added that piece of code to my script and this is what I see. Is there something else that i have to add to my script?

Re: Week number issue when week start made to Sunday

MK_QSL — Mon, 03 Jul 2017 10:11:08 GMT

Week(TempOrderDate+1) & '-' & WeekYear(TempOrderDate+1) as OrderWeekYear

Change field names accordingly.

Re: Week number issue when week start made to Sunday

apoorvasd — Mon, 03 Jul 2017 10:23:54 GMT

It still shows the same thing.

Re: Week number issue when week start made to Sunday

MK_QSL — Mon, 03 Jul 2017 10:25:23 GMT

What are the dates you are looking for?

Re: Week number issue when week start made to Sunday

apoorvasd — Mon, 03 Jul 2017 10:30:14 GMT

When I choose Week 53 of 2015, i have to see the following dates in my date field:

12/27/2015

12/28/2015

12/29/2015

12/30/2015

12/31/2015

1/1/2016

1/2/2016

Re: Week number issue when week start made to Sunday

MK_QSL — Mon, 03 Jul 2017 10:32:53 GMT

By using this...

Week(TempOrderDate+1) & '-' & WeekYear(TempOrderDate+1) as OrderWeekYear

I got what you are looking for.

Don't use WeekStart or anthing else.. If you are still not getting, upload your sample app

Re: Week number issue when week start made to Sunday

Anonymous — Mon, 03 Jul 2017 10:35:54 GMT

weekyear() doesn't seem to support a day offset, so I think you'll have to solve it the way Manish suggested.

Re: Week number issue when week start made to Sunday

apoorvasd — Mon, 03 Jul 2017 10:46:39 GMT

If you don't mind, can you upload your qvw file where you have worked this out?

If I don't find the solution still, I will upload my sample. Just that it would take sometime for me to upload the file that's the reason.

Thank you.

Re: Week number issue when week start made to Sunday

apoorvasd — Mon, 03 Jul 2017 10:47:16 GMT

Sure, thank you.

Re: Week number issue when week start made to Sunday

MK_QSL — Mon, 03 Jul 2017 10:55:29 GMT

FYI

Re: Week number issue when week start made to Sunday

apoorvasd — Mon, 03 Jul 2017 12:00:31 GMT

Thank you. I will have a look into it.

Attached is my app.

Re: Week number issue when week start made to Sunday

MK_QSL — Mon, 03 Jul 2017 12:15:41 GMT

In your app also it's working..

Re: Week number issue when week start made to Sunday

apoorvasd — Mon, 03 Jul 2017 12:20:11 GMT

Oh Yeah!! Did you make any change? (I don't see any though)

Re: Week number issue when week start made to Sunday

MK_QSL — Mon, 03 Jul 2017 12:21:45 GMT

Just reload the app.

Re: Week number issue when week start made to Sunday

apoorvasd — Mon, 03 Jul 2017 12:26:14 GMT

Haha ...that's surprising! Even I had reloaded. Anyways it's working now.

Thank you very much!

Re: Week number issue when week start made to Sunday

MK_QSL — Mon, 03 Jul 2017 12:27:02 GMT

Please close the thread by selecting correct answer