Get Max Value and Date

[d4rlie891]

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

[tresesco · Accepted solution]

This?

[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]

Hi,

Is it Possible to have it in Qliksense?

Thanks a lot

[d4rlie891]

Hi Sunny,

There is an error with this expressions :

- Error in expression : FirstSortedValue Takes 2-3 parameters

[shilpan]

add a comma

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

[d4rlie891]

Thanks for your help