topic Re: Need Help in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/417599#M564758 <HTML><HEAD></HEAD><BODY><P>A sample implementation is attached. Hope this helps.</P></BODY></HTML> Sun, 13 Jan 2013 11:35:49 GMT nagaiank 2013-01-13T11:35:49Z Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/417598#M564757 <HTML><HEAD></HEAD><BODY><P>i have to calculate&nbsp; view for months for this i have to subtract views for priviouse month from current month. </P><P>Raw Data:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="384"><TBODY><TR><TD height="20" width="64">Type</TD><TD width="64">Jan</TD><TD width="64">Feb</TD><TD width="64">Mar</TD><TD width="64">Apr</TD><TD width="64">May</TD></TR><TR><TD height="20">abc</TD><TD align="right">1000</TD><TD align="right">1060</TD><TD align="right">1120</TD><TD align="right">1180</TD><TD align="right">1240</TD></TR><TR><TD height="20">bca</TD><TD align="right">2000</TD><TD align="right">2040</TD><TD align="right">2080</TD><TD align="right">2120</TD><TD align="right">2160</TD></TR><TR><TD height="20">cab</TD><TD align="right">3000</TD><TD align="right">3070</TD><TD align="right">3140</TD><TD align="right">3210</TD><TD align="right">3280</TD></TR><TR><TD height="20">ghy</TD><TD align="right">4000</TD><TD align="right">4020</TD><TD align="right">4040</TD><TD align="right">4060</TD><TD align="right">4080</TD></TR><TR><TD height="20">ghj</TD><TD align="right">5000</TD><TD align="right">5080</TD><TD align="right">5160</TD><TD align="right">5240</TD><TD align="right">5320</TD></TR><TR><TD height="20">rty</TD><TD align="right">6000</TD><TD align="right">6090</TD><TD align="right">6180</TD><TD align="right">6270</TD><TD align="right">6360</TD></TR><TR><TD height="20">hio</TD><TD align="right">7000</TD><TD align="right">7020</TD><TD align="right">7040</TD><TD align="right">7060</TD><TD align="right">7080</TD></TR><TR><TD height="20">hdo</TD><TD align="right">8000</TD><TD align="right">8010</TD><TD align="right">8020</TD><TD align="right">8030</TD><TD align="right">8040</TD></TR><TR><TD height="20">gft</TD><TD align="right">9000</TD><TD align="right">9025</TD><TD align="right">9050</TD><TD align="right">9075</TD><TD align="right">9100</TD></TR></TBODY></TABLE><P></P><P>calculation:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 280px;"><TBODY><TR><TD height="20" width="64">View(Jan)</TD><TD width="72">View(Feb)</TD><TD width="73">View(Mar)</TD><TD width="71">View(Apr)</TD></TR><TR><TD align="right" height="20">60</TD><TD align="right">60</TD><TD align="right">60</TD><TD align="right">60</TD></TR><TR><TD align="right" height="20">40</TD><TD align="right">40</TD><TD align="right">40</TD><TD align="right">40</TD></TR><TR><TD align="right" height="20">70</TD><TD align="right">70</TD><TD align="right">70</TD><TD align="right">70</TD></TR><TR><TD align="right" height="20">20</TD><TD align="right">20</TD><TD align="right">20</TD><TD align="right">20</TD></TR><TR><TD align="right" height="20">80</TD><TD align="right">80</TD><TD align="right">80</TD><TD align="right">80</TD></TR><TR><TD align="right" height="20">90</TD><TD align="right">90</TD><TD align="right">90</TD><TD align="right">90</TD></TR><TR><TD align="right" height="20">20</TD><TD align="right">20</TD><TD align="right">20</TD><TD align="right">20</TD></TR><TR><TD align="right" height="20">10</TD><TD align="right">10</TD><TD align="right">10</TD><TD align="right">10</TD></TR><TR><TD align="right" height="20">25</TD><TD align="right">25</TD><TD align="right">25</TD><TD align="right">25</TD></TR></TBODY></TABLE><P>like for Jan view = Feb-jan</P><P> for Feb view= Mar-Feb</P><P>...................</P><P></P><P></P><P>Please suggest how to do this at time of loading or in expression in qlikview line chart and table.</P></BODY></HTML> Sun, 13 Jan 2013 10:35:41 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/417598#M564757 2013-01-13T10:35:41Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/417599#M564758 <HTML><HEAD></HEAD><BODY><P>A sample implementation is attached. Hope this helps.</P></BODY></HTML> Sun, 13 Jan 2013 11:35:49 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/417599#M564758 nagaiank 2013-01-13T11:35:49Z