Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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