Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
d4rlie891
Contributor III
Contributor III

Get Max Value and Date

Hi,

Anybody can help me, how to get what Date and Max Value in Month?

I just want to get Max Tot_Trans in a month and what the date of that Max Value in a month

Date               Year_Month     Tot_Trans

31/1/2017       2017/01            19,084,195.00

28/2/2017       2017/02             22,483,191.00

Date is t

Thanks A lot

Darmawan

1 Solution

Accepted Solutions
tresesco
MVP
MVP

6 Replies
tresesco
MVP
MVP

This?

Capture.JPG

sunny_talwar

If Tot_Trans is an expression, then may be this

Dimension

YEAR_MONTH

Expressions

FirstSortedValue(DATE - Aggr(Sum(Tot_Trans), DATE, YEAR_MONTH))

Max(Aggr(Sum(Tot_Trans), DATE, YEAR_MONTH))

d4rlie891
Contributor III
Contributor III
Author

Hi,

Is it Possible to have it in Qliksense?

Thanks a lot

d4rlie891
Contributor III
Contributor III
Author

Hi Sunny,

There is an error with this expressions :

- Error in expression : FirstSortedValue Takes 2-3 parameters

shilpan
Luminary Alumni
Luminary Alumni

add a comma

FirstSortedValue(DATE ,-aggr(sum([Sum(TOT_TRANS)]), DATE, YEAR_MONTH))

d4rlie891
Contributor III
Contributor III
Author

Thanks for your help