topic Re: max(Month Name) not working in QlikView

max(Month Name) not working

mahitham — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please help me on below issue.

I have a [Month Name] field in MMM YYYY format.

I have to show Max([Month Name]) in kpi instead of Apr 2018 getting 43.19k.

In the backend I have calculated [Month Name] from file name like below.

Pease help me to show Apr 2018

Thanks in advance.

ruanhaese — Fri, 22 Jun 2018 08:27:00 GMT

Try

Date( Max([Month Name]), 'MMM YYYY')

The date function formats the numeric value.

jyothish8807 — Fri, 22 Jun 2018 08:32:26 GMT

Else try this also:

Date(Max(Date#([Month Name], 'MMM YYYY')),'MMM YYYY')

Also set your number format as Date

Br,