
Contributor III
2024-01-05
10:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Display Bi-Weekly Dates in qlik sense for a given range.
Hi,
I have some given date ranges starting from January to March 15th. I would like to display these dates in bi-weekly in a Bar chart. Can you please help me out. Thanks.
2 Replies

MVP
2024-01-07
09:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Try like below
Date(DateField) as DateField,
Week(DateField) as WK,
'BIWK' & Ceil(Week(DateField)/2) as BIWK
Use BIWK in the bar chart
Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Please close the thread by marking correct answer & give likes if you like the post.
506 Views

Master
2024-01-07
09:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you can try one of the below logic:
Date(2+14*Div(create_date-2,14)) as BiweekStart
Date(Floor(Date,14,2)) as BiWeekDate
dual(text(weekstart(Date)),div(weekstart(Date),14)) as BiWeekDate,
504 Views
