Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator II

=Max(Year) not working

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.

YEAR ISSUE.png

7 Replies
Anil_Babu_Samineni

You may change your number format from custom to auto.

Capture.png

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bhavvibudagam
Creator II
Creator II
Author

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
Partner - Creator II
Partner - Creator II

Try

Year(Max(Date))

Shiva123
Creator
Creator

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

honeyasha
Contributor III
Contributor III

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

qlikviewwizard
Master II
Master II

Hi,

My guess is Date filed is like text.

Try like this.

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

Raed this article.

Why don’t my dates work?

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)