Bi Weekly Dimension in Master Calendar

M_P_ — Thu, 21 Apr 2022 11:47:53 GMT

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,

Re: Bi Weekly Dimension in Master Calendar

marcus_sommer — Thu, 21 Apr 2022 13:37:46 GMT

Maybe you could apply something like this:

ceil(week(Date) / 2) & '-' & (ceil(week(Date) / 2) + 1) as CombinedWeeks

- Marcus

topic Re: Bi Weekly Dimension in Master Calendar in App Development

Bi Weekly Dimension in Master Calendar

Re: Bi Weekly Dimension in Master Calendar