topic Re: Previous Year Sales !!!! in QlikView https://community.qlik.com/t5/QlikView/Previous-Year-Sales/m-p/805300#M284322 <HTML><HEAD></HEAD><BODY><P>Dim: Year</P><P>Exp: sales, Below(Column(1))</P></BODY></HTML> Wed, 31 Dec 2014 13:10:34 GMT anbu1984 2014-12-31T13:10:34Z Previous Year Sales !!!! https://community.qlik.com/t5/QlikView/Previous-Year-Sales/m-p/805298#M284320 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; ALl,</P><P></P><P></P><P>&nbsp;&nbsp; Can Help e below scenario Please !!!</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 290px; height: 97.14px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Year</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>sales</STRONG></TH></TR><TR><TD style="padding: 2px;">2014</TD><TD style="padding: 2px;">2000</TD></TR><TR><TD style="padding: 2px;">2013</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">2012</TD><TD style="padding: 2px;">1500</TD></TR></TBODY></TABLE><P></P><P></P><P>I want out put like this</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 289px; height: 99.94px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Year</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>current sales</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>previous sales</STRONG></TH></TR><TR><TD style="padding: 2px;">2014</TD><TD style="padding: 2px;">2000</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">2013</TD><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">1500</TD></TR><TR><TD style="padding: 2px;">2012</TD><TD style="padding: 2px;">1500</TD><TD style="padding: 2px;">-</TD></TR></TBODY></TABLE><P></P><P></P><P>And Drill down also is there if u select <STRONG>Quarter</STRONG> it should take&nbsp; <STRONG>Previous Quarter</STRONG>&nbsp; as well as <STRONG>month</STRONG> also is there .</P><P></P><P><STRONG>my main theme is if I select any thing it should take previous sales for that particular month or Quarter or Year</STRONG></P><P></P><P></P><P>please help me in this</P><P></P><P>Thanks in Advance</P></BODY></HTML> Wed, 31 Dec 2014 12:10:51 GMT https://community.qlik.com/t5/QlikView/Previous-Year-Sales/m-p/805298#M284320 2014-12-31T12:10:51Z Re: Previous Year Sales !!!! https://community.qlik.com/t5/QlikView/Previous-Year-Sales/m-p/805299#M284321 <HTML><HEAD></HEAD><BODY><P>Would above() function work for you, similar to attached?</P></BODY></HTML> Wed, 31 Dec 2014 13:00:05 GMT https://community.qlik.com/t5/QlikView/Previous-Year-Sales/m-p/805299#M284321 chrismarlow 2014-12-31T13:00:05Z Re: Previous Year Sales !!!! https://community.qlik.com/t5/QlikView/Previous-Year-Sales/m-p/805300#M284322 <HTML><HEAD></HEAD><BODY><P>Dim: Year</P><P>Exp: sales, Below(Column(1))</P></BODY></HTML> Wed, 31 Dec 2014 13:10:34 GMT https://community.qlik.com/t5/QlikView/Previous-Year-Sales/m-p/805300#M284322 anbu1984 2014-12-31T13:10:34Z