Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a bi weekly dimension in the master calendar in QlikSense.
I am already familiar with the following:
dual(text(weekstart(Datumsfeld)),div(weekstart(Datumsfeld),14)) as BiWeekDate,
div(weekstart(Datumsfeld),14) as BiWeek,
Dual(DayName(Floor(Datumsfeld,14,2))&' - '&DayName(Floor(Datumsfeld,14,2)+13),DayName(Floor(Datumsfeld,14,2))) as BiWeekconcat
But what I really want is a dimension purely on week numbers, so week 1-2, 3-4, etc, independent of the year, much like the week function ( Week(Datumsfeld) as Woche) I am using now.
I want to use this to compare this year's data to last year's, but in two-weekly increments, rather than weekly.
Can anyone help me please?
Many thanks,
MP
Maybe you could apply something like this:
ceil(week(Date) / 2) & '-' & (ceil(week(Date) / 2) + 1) as CombinedWeeks
- Marcus