Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

d4rlie891
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
MVP
MVP

Re: Get Max Value and Date

This?

Capture.JPG

6 Replies
MVP
MVP

Re: Get Max Value and Date

This?

Capture.JPG

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

d4rlie891
New Contributor III

Re: Get Max Value and Date

Hi,

Is it Possible to have it in Qliksense?

Thanks a lot

d4rlie891
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

shilpan9166
Contributor II

Re: Get Max Value and Date

add a comma

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

d4rlie891
New Contributor III

Re: Get Max Value and Date

Thanks for your help

Community Browser