topic Re: Get Latest Year for Sales in QlikView https://community.qlik.com/t5/QlikView/Get-Latest-Year-for-Sales/m-p/406705#M486575 <HTML><HEAD></HEAD><BODY><P>max(if(not IsNull(Sales),Year))</P><P></P><P>or</P><P></P><P>max({&lt;Sales={'*'}&gt;}Year)</P></BODY></HTML> Tue, 05 Mar 2013 08:56:04 GMT sivarajs 2013-03-05T08:56:04Z Get Latest Year for Sales https://community.qlik.com/t5/QlikView/Get-Latest-Year-for-Sales/m-p/406704#M486574 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I have a date dimension which has years 2000 up to 2025.</P><P>I need to get the latest year that has sales (in this case 2013), and need to display this value in a simple text object.</P><P></P><P>Can anybody provide some pointers to write this expression?</P><P></P><P>Thanks,</P><P>J</P></BODY></HTML> Tue, 05 Mar 2013 08:34:26 GMT https://community.qlik.com/t5/QlikView/Get-Latest-Year-for-Sales/m-p/406704#M486574 2013-03-05T08:34:26Z Re: Get Latest Year for Sales https://community.qlik.com/t5/QlikView/Get-Latest-Year-for-Sales/m-p/406705#M486575 <HTML><HEAD></HEAD><BODY><P>max(if(not IsNull(Sales),Year))</P><P></P><P>or</P><P></P><P>max({&lt;Sales={'*'}&gt;}Year)</P></BODY></HTML> Tue, 05 Mar 2013 08:56:04 GMT https://community.qlik.com/t5/QlikView/Get-Latest-Year-for-Sales/m-p/406705#M486575 sivarajs 2013-03-05T08:56:04Z Re: Get Latest Year for Sales https://community.qlik.com/t5/QlikView/Get-Latest-Year-for-Sales/m-p/406706#M486576 <HTML><HEAD></HEAD><BODY><P>Something like this should do it: max({&lt;SalesValue={'*'}&gt;} Year). Replace SalesVales and Year with the names of your dimensions.</P></BODY></HTML> Tue, 05 Mar 2013 08:56:04 GMT https://community.qlik.com/t5/QlikView/Get-Latest-Year-for-Sales/m-p/406706#M486576 Gysbert_Wassenaar 2013-03-05T08:56:04Z