topic KPI - Actual year and previous year in QlikView https://community.qlik.com/t5/QlikView/KPI-Actual-year-and-previous-year/m-p/1316101#M614462 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I just want to know the correct formula (in KPI) to show the figure of the previous year when selecting a year or month. I have used the next formula but it's not working at all:</P><P></P><P>Sum({$&lt;AÑO={$(=max([AÑO]-1))}&gt;}[Unidad Ventas])</P><P></P><P>The one in actual year is working correctly, so it is only this one I need to correct.</P><P></P><P>Thank you!!!</P><P></P><P>Joaquin.</P></BODY></HTML> Mon, 17 Jul 2017 07:30:38 GMT 2017-07-17T07:30:38Z KPI - Actual year and previous year https://community.qlik.com/t5/QlikView/KPI-Actual-year-and-previous-year/m-p/1316101#M614462 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I just want to know the correct formula (in KPI) to show the figure of the previous year when selecting a year or month. I have used the next formula but it's not working at all:</P><P></P><P>Sum({$&lt;AÑO={$(=max([AÑO]-1))}&gt;}[Unidad Ventas])</P><P></P><P>The one in actual year is working correctly, so it is only this one I need to correct.</P><P></P><P>Thank you!!!</P><P></P><P>Joaquin.</P></BODY></HTML> Mon, 17 Jul 2017 07:30:38 GMT https://community.qlik.com/t5/QlikView/KPI-Actual-year-and-previous-year/m-p/1316101#M614462 2017-07-17T07:30:38Z Re: KPI - Actual year and previous year https://community.qlik.com/t5/QlikView/KPI-Actual-year-and-previous-year/m-p/1316102#M614463 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">You can use for Month like this and similarly for year too.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Previous Month : Sum({&lt;DateID{$(=max(DateID)-1)}&gt;}Qv_Amount)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Current Month :</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum({&lt;DateID={$(=max(DateID))}&gt;}Qv_Amount)</P></BODY></HTML> Mon, 17 Jul 2017 07:48:08 GMT https://community.qlik.com/t5/QlikView/KPI-Actual-year-and-previous-year/m-p/1316102#M614463 2017-07-17T07:48:08Z Re: KPI - Actual year and previous year https://community.qlik.com/t5/QlikView/KPI-Actual-year-and-previous-year/m-p/1316103#M614464 <HTML><HEAD></HEAD><BODY><P>Hi Lohit, would you mind to show me the YEAR formula too, so i can compare results with mine.</P><P></P><P>Thank you very much!</P></BODY></HTML> Mon, 17 Jul 2017 08:03:42 GMT https://community.qlik.com/t5/QlikView/KPI-Actual-year-and-previous-year/m-p/1316103#M614464 2017-07-17T08:03:42Z Re: KPI - Actual year and previous year https://community.qlik.com/t5/QlikView/KPI-Actual-year-and-previous-year/m-p/1316104#M614465 <HTML><HEAD></HEAD><BODY><P>You can try using Calendar measures. Check this video out: <A href="http://help.qlik.com/en-US/sense/3.2/Content/Videos/Videos-creating-calendar-measures.htm" title="http://help.qlik.com/en-US/sense/3.2/Content/Videos/Videos-creating-calendar-measures.htm">Measures - Creating calendar measures ‒ Qlik Sense</A></P></BODY></HTML> Mon, 17 Jul 2017 20:35:10 GMT https://community.qlik.com/t5/QlikView/KPI-Actual-year-and-previous-year/m-p/1316104#M614465 2017-07-17T20:35:10Z