Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

Re: Max of Year issue

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
Highlighted
MVP
MVP

Re: Max of Year issue

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

Highlighted
Contributor II
Contributor II

Re: Max of Year issue

year.png

Highlighted
MVP
MVP

Re: Max of Year issue

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

Highlighted
Contributor II
Contributor II

Re: Max of Year issue

Please find the below attached file.

Highlighted
MVP
MVP

Re: Max of Year issue

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

Highlighted
Contributor II
Contributor II

Re: Max of Year issue

Thank you , Actually i was only doing wrong