topic Re: KPI CY vs. PY in App Development https://community.qlik.com/t5/App-Development/KPI-CY-vs-PY/m-p/1369644#M30880 <HTML><HEAD></HEAD><BODY><P>Not, because "Fecha" is the date of the POD. </P><P>Anywey, Is the same result</P></BODY></HTML> Tue, 25 Jul 2017 15:46:07 GMT jherrerae 2017-07-25T15:46:07Z KPI CY vs. PY https://community.qlik.com/t5/App-Development/KPI-CY-vs-PY/m-p/1369642#M30878 <HTML><HEAD></HEAD><BODY><P>Hi all.</P><P>I'm trying to compare de number of POD's of any year vs. number of POD's of previous year.</P><P>But it doesn't work!!!</P><P></P><P>Any Year</P><P></P><P>=Count({$&lt;Year={$(=Year(Fecha))}&gt;}Viaje)</P><P></P><P>Previous Year:</P><P></P><P>=Count({$&lt;Year={$(=(Year(Fecha)+1))}&gt;}Viaje)</P><P></P><P>But the result is... </P><P></P><P><IMG alt="Captura.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/171330_Captura.PNG" style="height: auto; width: auto;" /></P></BODY></HTML> Tue, 25 Jul 2017 15:28:07 GMT https://community.qlik.com/t5/App-Development/KPI-CY-vs-PY/m-p/1369642#M30878 jherrerae 2017-07-25T15:28:07Z Re: KPI CY vs. PY https://community.qlik.com/t5/App-Development/KPI-CY-vs-PY/m-p/1369643#M30879 <HTML><HEAD></HEAD><BODY><P>Previous year should be -1</P><P></P><P><STRONG>=Count({$&lt;Year={$(=(Year(Fecha)<SPAN style="color: #ff0000;">-</SPAN>1))}&gt;}Viaje)</STRONG></P></BODY></HTML> Tue, 25 Jul 2017 15:37:59 GMT https://community.qlik.com/t5/App-Development/KPI-CY-vs-PY/m-p/1369643#M30879 sunny_talwar 2017-07-25T15:37:59Z Re: KPI CY vs. PY https://community.qlik.com/t5/App-Development/KPI-CY-vs-PY/m-p/1369644#M30880 <HTML><HEAD></HEAD><BODY><P>Not, because "Fecha" is the date of the POD. </P><P>Anywey, Is the same result</P></BODY></HTML> Tue, 25 Jul 2017 15:46:07 GMT https://community.qlik.com/t5/App-Development/KPI-CY-vs-PY/m-p/1369644#M30880 jherrerae 2017-07-25T15:46:07Z Re: KPI CY vs. PY https://community.qlik.com/t5/App-Development/KPI-CY-vs-PY/m-p/1369645#M30881 <HTML><HEAD></HEAD><BODY><P>Not sure I understand?</P></BODY></HTML> Wed, 26 Jul 2017 00:34:11 GMT https://community.qlik.com/t5/App-Development/KPI-CY-vs-PY/m-p/1369645#M30881 sunny_talwar 2017-07-26T00:34:11Z