Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Creating Custom Calendar Week Range

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

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

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Creating Custom Calendar Week Range

See attached example.


talk is cheap, supply exceeds demand
2 Replies
Gysbert_Wassenaar
Not applicable

Re: Creating Custom Calendar Week Range

See attached example.


talk is cheap, supply exceeds demand
Not applicable

Re: Creating Custom Calendar Week Range

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