Creating Custom Calendar Week Range

Mon, 15 Apr 2013 16:43:23 GMT

Hi Community,

Had a question that I was hoping you all could share some light on. I'm trying to create a field that is a range of dates and am having some problems. I'd like to create a two week range starting on 1/6/2013 that goes from Sunday - Satruday of the following week. I've created a short example of the date and the field I'd like to create.

I've been trying to use the weekstart and weekend function without any success. I've tried using variables and looping through the recrod set but haven't landed on anytihng that works the way I want it to yet.

Any ideas on how to create something like this? Any builit in functions that can help?

Thanks

Date	Range
1/6/2013	1/6 - 1/19
1/7/2013	1/6 - 1/19
1/8/2013	1/6 - 1/19
1/9/2013	1/6 - 1/19
1/10/2013	1/6 - 1/19
1/11/2013	1/6 - 1/19
1/12/2013	1/6 - 1/19
1/13/2013	1/6 - 1/19
1/14/2013	1/6 - 1/19
1/15/2013	1/6 - 1/19
1/16/2013	1/6 - 1/19
1/17/2013	1/6 - 1/19
1/18/2013	1/6 - 1/19
1/19/2013	1/6 - 1/19
1/20/2013	1/20 - 2/2
1/21/2013	1/20 - 2/2
1/22/2013	1/20 - 2/2
1/23/2013	1/20 - 2/2
1/24/2013	1/20 - 2/2
1/25/2013	1/20 - 2/2
1/26/2013	1/20 - 2/2
1/27/2013	1/20 - 2/2

Re: Creating Custom Calendar Week Range

Gysbert_Wassenaar — Mon, 15 Apr 2013 17:15:21 GMT

See attached example.

Re: Creating Custom Calendar Week Range

Wed, 17 Apr 2013 14:23:28 GMT

Thank you. That is exactly what I needed. Much appreciated!!

topic Re: Creating Custom Calendar Week Range in QlikView

Creating Custom Calendar Week Range

Re: Creating Custom Calendar Week Range

Re: Creating Custom Calendar Week Range