Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
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))

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