topic Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/465770#M174008 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If I select a year I should get the data for the previous year in a chart.help me in writing the expression</P><P></P><P>Regards</P><P>Murali</P></BODY></HTML> Wed, 12 Jun 2013 13:48:58 GMT 2013-06-12T13:48:58Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/465770#M174008 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If I select a year I should get the data for the previous year in a chart.help me in writing the expression</P><P></P><P>Regards</P><P>Murali</P></BODY></HTML> Wed, 12 Jun 2013 13:48:58 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/465770#M174008 2013-06-12T13:48:58Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/465771#M174009 <HTML><HEAD></HEAD><BODY><P>if you select the year in the field "calendar_year', try the following formula in your chart:</P><P></P><P>sum({&lt;calendar_year= {$(=Only([calendar_year])-1)}&gt;} data)</P><P></P><P>regards,</P><P>marcel</P></BODY></HTML> Wed, 12 Jun 2013 13:54:37 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/465771#M174009 2013-06-12T13:54:37Z