
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Master Calendar with Sequence Dates
Hi,
I have created the master calendar by using start date and end date.But the requirement is while generating master calendar I have to generate sequence of dates like 01/01/2019,03/01/2019,05/01/2019,07/01/2019,09/01/2019 etc.....instead of all dates.
Any suggestions please.
- Tags:
- qlikview_scripting
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi!
Try this:
TempCalender:
LOAD * Where Mod(TempDate, 2) = 0
;
load
Date($(vMinDate) + IterNo()-1) as TempDate
AutoGenerate 1 While $(vMinDate) + IterNo()-1 <=$(vMaxDate)
;
Bests,
Jaime.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi!
It may depend on how you create your Master Calendar. Can you share the code of your Calendar?
A possible idea if you want to test it yourself: add a "Where" clause in your Master Calendar with something like
Where Mod(Date, 2) = 1
This condition will generate a sequence like the one you suggest.
Bests,
Jaime.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
TempCalender:
load
Date($(vMinDate) + IterNo()-1) as TempDate
AutoGenerate 1 While $(vMinDate) + IterNo()-1 <=$(vMaxDate)
;


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi!
Try this:
TempCalender:
LOAD * Where Mod(TempDate, 2) = 0
;
load
Date($(vMinDate) + IterNo()-1) as TempDate
AutoGenerate 1 While $(vMinDate) + IterNo()-1 <=$(vMaxDate)
;
Bests,
Jaime.
