# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
New Contributor II

## Problem with 31.12.2018: week(31.12.2018) = 1 but year (31.12.2018) = 2018

Hello,

I have "date" fields in the format dd.mm.yyyy. I use this field for dimensions in charts.

Example 1:
1st Dimenstion:

`=week(date)`

2nd Dimension:

`=year(date)`

Example 2:
Dimension:

`=year(date)&num(week(date),'_00')`

Now the Problem:
For the date="31.12.2018" the function week(date) delivers correct "1" but the function year(date) delivers "2018". Of course this is correct, but not helpful.

Any ideas?

Regards
Georg

Labels (3)

• ### year

1 Solution

Accepted Solutions
Luminary

4 Replies
Luminary

## Re: Problem with 31.12.2018: week(31.12.2018) = 1 but year (31.12.2018) = 2018

New Contributor II

## Re: Problem with 31.12.2018: week(31.12.2018) = 1 but year (31.12.2018) = 2018

Thanks for the note!

If I set "BrokenWeeks=1", week (31.12.2018) returns 53 and the charts look meaningful again.
Unfortunately there is no week 53 in 2018. All other calendars say that 31.12.2018 belongs to the first week of 2019.
So "BrokenWeeks=1" is just an ugly workaround that does not fit with other systems.

Luminary

## Re: Problem with 31.12.2018: week(31.12.2018) = 1 but year (31.12.2018) = 2018

New Contributor II

## Re: Problem with 31.12.2018: week(31.12.2018) = 1 but year (31.12.2018) = 2018

Thanks for the outstanding hint! You saved my day 😉