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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
fabio182
Creator II
Creator II

Convert week in month

Hi gays,

It's possible to know which month is one week

For example: Week1 = January

Thanks you !!!

1 Solution

Accepted Solutions
maxgro
MVP
MVP

you need an year and a week number

then you can use month and makeweekdate (replace with your field)

=month(makeweekdate(1999,6))

View solution in original post

3 Replies
anbu1984
Master III
Master III

=Month(MakeWeekDate(2014,Week_no,1)+1)

maxgro
MVP
MVP

you need an year and a week number

then you can use month and makeweekdate (replace with your field)

=month(makeweekdate(1999,6))

fabio182
Creator II
Creator II
Author

Thank you so much Massino !!!