topic Re: Get Max Value and Date in QlikView

Get Max Value and Date

d4rlie891 — Wed, 21 Feb 2018 11:53:17 GMT

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

tresB — Wed, 21 Feb 2018 12:04:28 GMT

This?

sunny_talwar — Wed, 21 Feb 2018 12:20:11 GMT

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 — Thu, 22 Feb 2018 02:27:12 GMT

Hi,

Is it Possible to have it in Qliksense?

Thanks a lot

d4rlie891 — Thu, 22 Feb 2018 02:55:39 GMT

Hi Sunny,

There is an error with this expressions :

- Error in expression : FirstSortedValue Takes 2-3 parameters

shilpan — Thu, 22 Feb 2018 04:27:37 GMT

add a comma

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

d4rlie891 — Thu, 22 Feb 2018 05:53:08 GMT

Thanks for your help