topic Display the max(total MonthName) in QlikView

Display the max(total MonthName)

Fri, 24 Jun 2011 06:24:37 GMT

Hi,

I have a list that has a month number and MonthName

e.g. MonthNum MonthName

11101 Jul

11102 Aug

11103 Sep

When a range of months is selected e.g. July to September I want the title of the report to say "Sep YTD Report" using the max(total) function to determine the most recent month selected.

so using max(total MonthName) I get nothing whereas using max(totalMonthNum) will give 11103.

Can this be done for non numeric values like month names?

Thanks

David

Display the max(total MonthName)

kaushiknsolanki — Fri, 24 Jun 2011 06:30:19 GMT

Hi,

Try just max(MonthName)

Regards,

Kaushik Solanki

Display the max(total MonthName)

Anonymous — Fri, 24 Jun 2011 06:34:28 GMT

Hm, without testing, this might work:

=maxstring(aggr(dual(MonthName, Max(MonthNum)), MonthNum))

Not sure if it's a bit overkill though and there's likely an easier way but this was the first thing that popped in my mind.

Re: Display the max(total MonthName)

Fri, 24 Jun 2011 06:35:01 GMT

Hi,

EDITED: I replied saying it didnt work at the same time the correct answer was posted

Thanks Johannes that worked perfectly

The max(MonthName) didn't work sorry.

Thanks

David