topic Max in QlikView https://community.qlik.com/t5/QlikView/Max/m-p/329853#M705161 <HTML><HEAD></HEAD><BODY><P>Hi <A _jive_internal="true" class="jiveTT-hover-user jive-username-link" href="https://community.qlik.com/people/manish05" id="jive-8014824308981362451244">manish05</A>,</P><P>You can use monthname() function or you can pass both year and month. So, max of month is selected from the particular year only.</P><P></P><P>.</P><P>Ashutosh</P></BODY></HTML> Tue, 01 May 2012 12:55:37 GMT 2012-05-01T12:55:37Z Max https://community.qlik.com/t5/QlikView/Max/m-p/329852#M705160 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P></P><P>I have 2 years 2010 and 2011 , 2010 have months from jan to dec and 2011 have months from jan to Nov.&nbsp; </P><P></P><P>I want the max(Month) of 2011 that is Nov&nbsp; not Dec, when i&nbsp; clear the selection </P></BODY></HTML> Tue, 01 May 2012 12:49:14 GMT https://community.qlik.com/t5/QlikView/Max/m-p/329852#M705160 2012-05-01T12:49:14Z Max https://community.qlik.com/t5/QlikView/Max/m-p/329853#M705161 <HTML><HEAD></HEAD><BODY><P>Hi <A _jive_internal="true" class="jiveTT-hover-user jive-username-link" href="https://community.qlik.com/people/manish05" id="jive-8014824308981362451244">manish05</A>,</P><P>You can use monthname() function or you can pass both year and month. So, max of month is selected from the particular year only.</P><P></P><P>.</P><P>Ashutosh</P></BODY></HTML> Tue, 01 May 2012 12:55:37 GMT https://community.qlik.com/t5/QlikView/Max/m-p/329853#M705161 2012-05-01T12:55:37Z Max https://community.qlik.com/t5/QlikView/Max/m-p/329854#M705162 <HTML><HEAD></HEAD><BODY><P>Can you please give a example</P></BODY></HTML> Tue, 01 May 2012 13:04:48 GMT https://community.qlik.com/t5/QlikView/Max/m-p/329854#M705162 2012-05-01T13:04:48Z Max https://community.qlik.com/t5/QlikView/Max/m-p/329855#M705163 <HTML><HEAD></HEAD><BODY><P>yeah sure,</P><P>Just give a sample app with your requirement so that I can give more accurate example.</P></BODY></HTML> Tue, 01 May 2012 13:35:18 GMT https://community.qlik.com/t5/QlikView/Max/m-p/329855#M705163 2012-05-01T13:35:18Z Max https://community.qlik.com/t5/QlikView/Max/m-p/329856#M705164 <HTML><HEAD></HEAD><BODY><P>I don't have any app for it yaar ....&nbsp; i just tried it with few values in excel with columns Sales and Date (m/d/yyyy).</P></BODY></HTML> Tue, 01 May 2012 13:59:23 GMT https://community.qlik.com/t5/QlikView/Max/m-p/329856#M705164 2012-05-01T13:59:23Z Max https://community.qlik.com/t5/QlikView/Max/m-p/329857#M705165 <HTML><HEAD></HEAD><BODY><P>i have done like this</P><P> <STRONG>Month(MonthName(Max(Date)))&nbsp; </STRONG>its working .... </P><P></P><P>is there any other way also??? </P></BODY></HTML> Tue, 01 May 2012 14:01:36 GMT https://community.qlik.com/t5/QlikView/Max/m-p/329857#M705165 2012-05-01T14:01:36Z Max https://community.qlik.com/t5/QlikView/Max/m-p/329858#M705166 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Simply use Month(Max(Date)) no need monthname in it.</P><P></P><P>Celambarasan</P></BODY></HTML> Tue, 01 May 2012 14:37:04 GMT https://community.qlik.com/t5/QlikView/Max/m-p/329858#M705166 CELAMBARASAN 2012-05-01T14:37:04Z