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: 
Gowtham174
Creator
Creator

Max Weeknumber

Hi All,

Can you please help me to show the Max week number in text for the below, I need to display weeknumber

  

WeekNumberYearNew
012019
022019
032019
042019
522018

Thanks,

Gowtham

2 Replies
swuehl
MVP
MVP

Not sure I understand, but shouldn't it be just

=Max(WeekNumber)

?

swuehl
MVP
MVP

Or if you want the max weeknumber of the max year

=Max({<YearNew ={$(=Max(YearNew))}>} WeekNumber)