topic Re: max year displayed in QlikView https://community.qlik.com/t5/QlikView/max-year-displayed/m-p/1261017#M397728 <HTML><HEAD></HEAD><BODY><P>I think max({1} field name) will give you the answer.</P></BODY></HTML> Tue, 03 Jan 2017 11:52:48 GMT pipuindia99 2017-01-03T11:52:48Z max year displayed https://community.qlik.com/t5/QlikView/max-year-displayed/m-p/1261013#M397724 <HTML><HEAD></HEAD><BODY><P>Hello Guys,</P><P></P><P>Happy new year and best wishes <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I have a year fields that contains year since 2013, I would like to display only year 2017. Any idea please?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 03 Jan 2017 08:01:55 GMT https://community.qlik.com/t5/QlikView/max-year-displayed/m-p/1261013#M397724 master_student 2017-01-03T08:01:55Z Re: max year displayed https://community.qlik.com/t5/QlikView/max-year-displayed/m-p/1261014#M397725 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>You can use max(year)</P></BODY></HTML> Tue, 03 Jan 2017 09:25:43 GMT https://community.qlik.com/t5/QlikView/max-year-displayed/m-p/1261014#M397725 saimahasan 2017-01-03T09:25:43Z Re: max year displayed https://community.qlik.com/t5/QlikView/max-year-displayed/m-p/1261015#M397726 <HTML><HEAD></HEAD><BODY><P>You want the max year or the 2017 as the year ??</P><P></P><P>if(Year='2017',Year)</P><P>or </P><P>based on selection max year </P><P>max(Year)</P></BODY></HTML> Tue, 03 Jan 2017 09:42:31 GMT https://community.qlik.com/t5/QlikView/max-year-displayed/m-p/1261015#M397726 avinashelite 2017-01-03T09:42:31Z Re: max year displayed https://community.qlik.com/t5/QlikView/max-year-displayed/m-p/1261016#M397727 <HTML><HEAD></HEAD><BODY><P>Create a text Box and write the Expression max(Year). But when ever there is a change in selection like if Old Years are selected, this Text Box shows the corresponding selection or max of the corresponding selections. If we want to show the text Box max year irrespective of selections, then use Max({1} Year).</P></BODY></HTML> Tue, 03 Jan 2017 11:37:11 GMT https://community.qlik.com/t5/QlikView/max-year-displayed/m-p/1261016#M397727 parimikittu 2017-01-03T11:37:11Z Re: max year displayed https://community.qlik.com/t5/QlikView/max-year-displayed/m-p/1261017#M397728 <HTML><HEAD></HEAD><BODY><P>I think max({1} field name) will give you the answer.</P></BODY></HTML> Tue, 03 Jan 2017 11:52:48 GMT https://community.qlik.com/t5/QlikView/max-year-displayed/m-p/1261017#M397728 pipuindia99 2017-01-03T11:52:48Z