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: 
jeevays7
Partner - Creator III
Partner - Creator III

get date of maximum value

Hi all,

I have data like below.

 

DateMonthValue
1-Jan-17Jan2
2-Jan-17Jan3
3-Jan-17Jan4
4-Jan-17Jan5
2-Feb-17Feb3
3-Feb-17Feb2
4-Feb-17Feb4
5-Feb-17Feb5
1-Mar-17Mar8
2-Mar-17Mar2
3-Mar-17Mar1
4-Mar-17Mar4

from above table i need the max value of each month and the date of the max value of the month.

output table is below:

   

MonthMax ValueDate
Jan54-Jan-17
Feb55-Feb-17
Mar81-Mar-17

Please suggest me.

1 Solution

Accepted Solutions
sunny_talwar

May be this

Dimension

Month

Expression

Max(Value)

FirstSortedValue(Date, -Value)

View solution in original post

1 Reply
sunny_talwar

May be this

Dimension

Month

Expression

Max(Value)

FirstSortedValue(Date, -Value)