topic Re: Calculate Above values in QlikView https://community.qlik.com/t5/QlikView/Calculate-Above-values/m-p/658526#M240318 <HTML><HEAD></HEAD><BODY><P>what's the question?</P><P>you have Sales and want to calculated the average (last colum)?</P></BODY></HTML> Sat, 26 Jul 2014 16:53:29 GMT maxgro 2014-07-26T16:53:29Z Calculate Above values https://community.qlik.com/t5/QlikView/Calculate-Above-values/m-p/658525#M240317 <HTML><HEAD></HEAD><BODY><P>Dear Qlikview Users,</P><P></P><P>I have one tough situation in developing a qlikview dashboard, that is how to calculate sales of New York in the past months? Please find the sample data below:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="353"><TBODY><TR><TD height="18" width="72">City</TD><TD width="84">Month</TD><TD width="72">Sales</TD><TD width="125">Avg Above Sales</TD></TR><TR><TD height="18">NewYork</TD><TD align="right" class="xl63">2013/7/1</TD><TD align="right">1000</TD><TD align="right">1000</TD></TR><TR><TD height="18">NewYork</TD><TD align="right" class="xl63">2013/8/1</TD><TD align="right">1200</TD><TD align="right">1100</TD></TR><TR><TD height="18">NewYork</TD><TD align="right" class="xl63">2013/9/1</TD><TD align="right">1500</TD><TD align="right">1233.333333</TD></TR><TR><TD height="18">NewYork</TD><TD align="right" class="xl63">2013/10/1</TD><TD align="right">2000</TD><TD align="right">1425</TD></TR><TR><TD height="18">NewYork</TD><TD align="right" class="xl63">2013/11/1</TD><TD align="right">3000</TD><TD align="right">1740</TD></TR><TR><TD height="18">NewYork</TD><TD align="right" class="xl63">2013/12/1</TD><TD align="right">1800</TD><TD align="right">1750</TD></TR><TR><TD height="18">NewYork</TD><TD align="right" class="xl63">2014/1/1</TD><TD align="right">1200</TD><TD align="right">1671.428571</TD></TR></TBODY></TABLE><P>The last column, always calculate the average sales amount from 2013-07-1 to current month.</P><P></P><P>I really have no idea, can you please help on this? Many thanks.</P></BODY></HTML> Sat, 26 Jul 2014 14:57:17 GMT https://community.qlik.com/t5/QlikView/Calculate-Above-values/m-p/658525#M240317 2014-07-26T14:57:17Z Re: Calculate Above values https://community.qlik.com/t5/QlikView/Calculate-Above-values/m-p/658526#M240318 <HTML><HEAD></HEAD><BODY><P>what's the question?</P><P>you have Sales and want to calculated the average (last colum)?</P></BODY></HTML> Sat, 26 Jul 2014 16:53:29 GMT https://community.qlik.com/t5/QlikView/Calculate-Above-values/m-p/658526#M240318 maxgro 2014-07-26T16:53:29Z