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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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
Champion III
Champion III

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

=Max(WeekNumber)

?

swuehl
Champion III
Champion III

Or if you want the max weeknumber of the max year

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