topic Re: =Max(Year) not working in QlikView

=Max(Year) not working

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

Hi Experts,

Can any one please help me on below issue.

From my date field when i tried to find max(Year) i am getting 2.02k instead of 2018.

Please help me on this. Same issue for Month and Monthname as well max(Month) or Max(Monthname) is also not working.

Anil_Babu_Samineni — Fri, 25 May 2018 09:36:01 GMT

You may change your number format from custom to auto.

bhavvibudagam — Fri, 25 May 2018 10:04:31 GMT

Hi Anil,

Thanks for your reply. Its working fine in Charts under measures.

But in text object I have to show max(Year)&''&Max(Month) there i am getting the issue.

sudhirpkuwar — Fri, 25 May 2018 10:24:31 GMT

Try

Year(Max(Date))

Shiva123 — Fri, 25 May 2018 17:04:30 GMT

can u attach the file ? may be there is something issue with your date field

honeyasha — Sat, 26 May 2018 17:33:02 GMT

You can use =max(Year) in text object to get single row input .

qlikviewwizard — Sun, 27 May 2018 01:00:06 GMT

Hi,

My guess is Date filed is like text.

Try like this.

=Max(Year(Date(Date#(Date,'DD/MM/YYYY'))))

Raed this article.

Anil_Babu_Samineni — Mon, 28 May 2018 03:01:11 GMT

Still i am not seen any error your measure? Can you post screenshot