Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New 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
Highlighted
MVP
MVP

Re: Get Max Value and Date

6 Replies
Highlighted
MVP
MVP

Re: Get Max Value and Date

Highlighted

Re: Get Max Value and Date

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))

Highlighted
New Contributor III

Re: Get Max Value and Date

Hi,

Is it Possible to have it in Qliksense?

Thanks a lot

Highlighted
New Contributor III

Re: Get Max Value and Date

Hi Sunny,

There is an error with this expressions :

- Error in expression : FirstSortedValue Takes 2-3 parameters

Highlighted
Luminary
Luminary

Re: Get Max Value and Date

add a comma

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

Highlighted
New Contributor III

Re: Get Max Value and Date

Thanks for your help