Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
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