topic Expression calculation for (only) last month from selected months? in QlikView https://community.qlik.com/t5/QlikView/Expression-calculation-for-only-last-month-from-selected-months/m-p/631419#M543451 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table with an expression that calculated Average Survey Answers over a selected period of time (months). I have to add another expression to do the same calculation - Average Survey Answers, but for the last month from the selected months. So for example if I select Apr, May, Jun and July I want my second expression to display the results for July only, as July is the last month is my selection. My expression is based on a variable called. Any ideas? I cannot post the dashboard as it's client work...</P><P><STRONG></STRONG></P><P><BR /> </P></BODY></HTML> Tue, 13 May 2014 15:01:17 GMT 2014-05-13T15:01:17Z Expression calculation for (only) last month from selected months? https://community.qlik.com/t5/QlikView/Expression-calculation-for-only-last-month-from-selected-months/m-p/631419#M543451 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table with an expression that calculated Average Survey Answers over a selected period of time (months). I have to add another expression to do the same calculation - Average Survey Answers, but for the last month from the selected months. So for example if I select Apr, May, Jun and July I want my second expression to display the results for July only, as July is the last month is my selection. My expression is based on a variable called. Any ideas? I cannot post the dashboard as it's client work...</P><P><STRONG></STRONG></P><P><BR /> </P></BODY></HTML> Tue, 13 May 2014 15:01:17 GMT https://community.qlik.com/t5/QlikView/Expression-calculation-for-only-last-month-from-selected-months/m-p/631419#M543451 2014-05-13T15:01:17Z Re: Expression calculation for (only) last month from selected months? https://community.qlik.com/t5/QlikView/Expression-calculation-for-only-last-month-from-selected-months/m-p/631420#M543452 <HTML><HEAD></HEAD><BODY><P>Katarzyna,</P><P>See a generic idea in the attached.&nbsp; I'm using set analysis comparing Month with the max(Month).</P><P></P><P>Regards,</P><P>Michael</P></BODY></HTML> Tue, 13 May 2014 15:16:40 GMT https://community.qlik.com/t5/QlikView/Expression-calculation-for-only-last-month-from-selected-months/m-p/631420#M543452 Anonymous 2014-05-13T15:16:40Z Re: Expression calculation for (only) last month from selected months? https://community.qlik.com/t5/QlikView/Expression-calculation-for-only-last-month-from-selected-months/m-p/631421#M543453 <HTML><HEAD></HEAD><BODY><P>Thank you Michael, that worked! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 14 May 2014 09:15:54 GMT https://community.qlik.com/t5/QlikView/Expression-calculation-for-only-last-month-from-selected-months/m-p/631421#M543453 2014-05-14T09:15:54Z