topic CY vs PY Comparison in Line chart in QlikView https://community.qlik.com/t5/QlikView/CY-vs-PY-Comparison-in-Line-chart/m-p/661330#M241046 <HTML><HEAD></HEAD><BODY><P>I want to show Details Of CY and PY in single report..</P><P>based on Year and Month.</P><P></P><P>For example..if i selected Current Year and May month...same chart need to display Previous Year and Previous year may month..</P></BODY></HTML> Mon, 06 Oct 2014 06:14:58 GMT balasundaram 2014-10-06T06:14:58Z CY vs PY Comparison in Line chart https://community.qlik.com/t5/QlikView/CY-vs-PY-Comparison-in-Line-chart/m-p/661330#M241046 <HTML><HEAD></HEAD><BODY><P>I want to show Details Of CY and PY in single report..</P><P>based on Year and Month.</P><P></P><P>For example..if i selected Current Year and May month...same chart need to display Previous Year and Previous year may month..</P></BODY></HTML> Mon, 06 Oct 2014 06:14:58 GMT https://community.qlik.com/t5/QlikView/CY-vs-PY-Comparison-in-Line-chart/m-p/661330#M241046 balasundaram 2014-10-06T06:14:58Z Re: CY vs PY Comparison in Line chart https://community.qlik.com/t5/QlikView/CY-vs-PY-Comparison-in-Line-chart/m-p/661331#M241047 <HTML><HEAD></HEAD><BODY><P>Create a variable vPrevYear = Max(Year) - 1</P><P></P><P>Use these two expressions</P><P>Sum({&lt;Year={$(=Max(Year))}, Month={$(=Max(Month))}&gt;} [Your Field])</P><P></P><P>Sum({&lt;Year={$(vPrevYear)}, Month={$(=Max(Month))}&gt;} [Your Field])</P></BODY></HTML> Mon, 06 Oct 2014 06:20:16 GMT https://community.qlik.com/t5/QlikView/CY-vs-PY-Comparison-in-Line-chart/m-p/661331#M241047 senpradip007 2014-10-06T06:20:16Z