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.