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

Weekname(date) shows wrong week in 2021

Hi, 

unfortunately a function in qlikview-script is not working correctly: 

weekname(date) shows the wrong week - for the 01.01.2021 it should be week "2020-53", but qlikview shows 2021-01; the weeks afterwards are wrong as well...

Is there a possibility that this error gets fixed?

Greetings

Jakob

Labels (3)
1 Solution

Accepted Solutions
yassinemhadhbi
Creator II
Creator II

Good morning

In QlikView variables ( Main tab : first tab in the script ) make sure that the variable BrokenWeeks is set to 0

Best Regards
Yassine Mhadhbi

View solution in original post

3 Replies
Taoufiq_Zarra

@jakobjosef for example

=weekname('01/01/2021',0) gives :

Taoufiq_Zarra_0-1612788944418.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
yassinemhadhbi
Creator II
Creator II

Good morning

In QlikView variables ( Main tab : first tab in the script ) make sure that the variable BrokenWeeks is set to 0

Best Regards
Yassine Mhadhbi
jakobjosef
Creator II
Creator II
Author

Dear Yassinemhadbi, 

this was exactly what I was looking for. Thank you so much for your hint, i would have never tried it this way. 
Thanks a lot, also to your hint Taofiq!
Jakob