Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
M_P_
Contributor
Contributor

Bi Weekly Dimension in Master Calendar

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

Labels (1)
1 Reply
marcus_sommer

Maybe you could apply something like this:

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

- Marcus