Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
lost_rabbit
Contributor III
Contributor III
‎2023-04-05 10:57 AM

Get Total number of ISO Weeks by Year

How do  you calculate the total number of iso weeks by year on the front end without a calendar dimension table in your data model?

Eg:

2020 - 53 weeks

2023 - 52 weeks

I need the number of weeks based on Year to calculate average .

Eg:

Avg Vol of 2020 would be Vol / 53 (No of ISO weeks in 2020)

Labels (1)
Labels
438 Views
0 Likes
1 Reply
brunobertels
Master
Master
‎2023-04-07 05:27 AM

Hello

To know if the annual calendar has 52 or 53 weeks, you must therefore know the day of January 1st. If January 1 falls on a Thursday (regular year and leap year) or Wednesday (leap year only) the ISO year will have 53 weeks. In all other cases the ISO year will have 52 weeks.

 

A leap year have 366 days , regular year have 365 days 

hope it helps 

403 Views
0 Likes