
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calendar - date range selection
Dear Community,
I would like to use calendar for date range selection purpose.
Example:
However, the condition is we don't have data for every day, only 1st of every month has data,
so if user clicks at 2nd, or 11st or 28th..., the data will not be reflected.
Can QlikView auto select 1st of month? no matter which date user click on that month.
Thanks,
Chanel
Accepted Solutions

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Create another variable and use this variable in your set analysis
vMonthEndDate =MonthEnd(vEndDate)
Regards,
Jagan.

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
In the set analysis expression or variable you just set to MonthStart(vToDate), this will work. Even if you do not set to Monthstart also in set analysis we will use >= and <=.
Regards,
Jagan.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Jagan for prompt response.
I am unable to change the variable in calendar to MonthStart().
I have attached the document, appreciate if you could help to modify.
Thanks,
Chanel

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Create another variable and use this variable in your set analysis
vMonthEndDate =MonthEnd(vEndDate)
Regards,
Jagan.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your help, I got it!
Anyone has the same problem can refer to the attached document.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am also quite new in Qlik calendar, I ever reckon that the calendar date select must be very similar to some UI calendar control, I did the investigation but got no information useful. Fortunately, the attachment here helps.
