Display Bi-Weekly Dates in qlik sense for a given range.

[Sree_1]

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.

[MayilVahanan]

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

[anat]

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,