Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahajan
Contributor II
Contributor II

Max of Year issue

Hi All,

In my data set I have only Year no date column is there , when  I am taking 

Max(year) it is giving me 1905 as output . I have tried num() and date#() but still issue is not resolved.

Can any one help me out!!!

Thanx to All

1 Solution

Accepted Solutions
tresesco
MVP
MVP

You are not doing max(year), you are doing date(max(year)) and they are different. What are you expecting as output? A date, may be 1-1-maxyear ? if so, try like:

MakeDate(Max(year))

View solution in original post

6 Replies
tresesco
MVP
MVP

Could you share a screenshot of how your year field data look like? 

Mahajan
Contributor II
Contributor II
Author

year.png

tresesco
MVP
MVP

Data looks to be fine. Can you share your app with only year field and let us try/investigate?

Mahajan
Contributor II
Contributor II
Author

Please find the below attached file.

tresesco
MVP
MVP

You are not doing max(year), you are doing date(max(year)) and they are different. What are you expecting as output? A date, may be 1-1-maxyear ? if so, try like:

MakeDate(Max(year))

Mahajan
Contributor II
Contributor II
Author

Thank you , Actually i was only doing wrong