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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (2)
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
MVP
MVP

@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