topic Re: calculating variations by week in App Development https://community.qlik.com/t5/App-Development/calculating-variations-by-week/m-p/1319912#M28481 <HTML><HEAD></HEAD><BODY><P>Is this something you need in the script or front end?</P></BODY></HTML> Tue, 06 Jun 2017 13:56:26 GMT sunny_talwar 2017-06-06T13:56:26Z calculating variations by week https://community.qlik.com/t5/App-Development/calculating-variations-by-week/m-p/1319911#M28480 <HTML><HEAD></HEAD><BODY><P>hello,</P><P></P><P>I have to calculate the result difference from a week day to another, but I didn't found any solution.</P><P></P><P>Here is the objective (see "variation" column):</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sales ($)</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Variation ($)</TH></TR><TR><TD style="padding: 2px;">29/5/2017</TD><TD style="padding: 2px;">Apples</TD><TD style="padding: 2px;">25k</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">29/5/2017</TD><TD style="padding: 2px;">Bananas</TD><TD style="padding: 2px;">10k</TD><TD style="padding: 2px;">-</TD></TR><TR><TD>29/5/2017</TD><TD>Lemons</TD><TD>6k</TD><TD>-</TD></TR><TR><TD style="padding: 2px;">5/6/2017</TD><TD style="padding: 2px;">Apples</TD><TD style="padding: 2px;">21k</TD><TD style="padding: 2px;"><STRONG style="font-size: 12pt;">+4k</STRONG></TD></TR><TR><TD style="padding: 2px;">5/6/2017</TD><TD style="padding: 2px;">Bananas</TD><TD style="padding: 2px;">23k</TD><TD style="padding: 2px;"><STRONG style="font-size: 12pt;">+13k</STRONG></TD></TR><TR><TD style="padding: 2px;">5/6/2017</TD><TD style="padding: 2px;">Oranges</TD><TD style="padding: 2px;">19k</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">12/6/2017</TD><TD style="padding: 2px;">Apples</TD><TD style="padding: 2px;">39k</TD><TD style="padding: 2px;"><STRONG style="font-size: 12pt;">+18k</STRONG></TD></TR><TR><TD style="padding: 2px;">12/6/2017</TD><TD style="padding: 2px;">Bananas</TD><TD style="padding: 2px;">22k</TD><TD style="padding: 2px;"><STRONG style="font-size: 12pt;">-1k</STRONG></TD></TR><TR><TD style="padding: 2px;">12/6/2017</TD><TD style="padding: 2px;">Oranges</TD><TD style="padding: 2px;">12k</TD><TD style="padding: 2px;"><STRONG style="font-size: 12pt;">-7k</STRONG></TD></TR></TBODY></TABLE><P></P><P>Do you have any idea?</P><P></P><P>Many thanks in advance,</P><P></P><P>Nicolas</P></BODY></HTML> Tue, 06 Jun 2017 13:55:15 GMT https://community.qlik.com/t5/App-Development/calculating-variations-by-week/m-p/1319911#M28480 2017-06-06T13:55:15Z Re: calculating variations by week https://community.qlik.com/t5/App-Development/calculating-variations-by-week/m-p/1319912#M28481 <HTML><HEAD></HEAD><BODY><P>Is this something you need in the script or front end?</P></BODY></HTML> Tue, 06 Jun 2017 13:56:26 GMT https://community.qlik.com/t5/App-Development/calculating-variations-by-week/m-p/1319912#M28481 sunny_talwar 2017-06-06T13:56:26Z Re: calculating variations by week https://community.qlik.com/t5/App-Development/calculating-variations-by-week/m-p/1319913#M28482 <HTML><HEAD></HEAD><BODY><P>preferably in the front end because the script has an automated load through several excel files.</P></BODY></HTML> Tue, 06 Jun 2017 14:00:15 GMT https://community.qlik.com/t5/App-Development/calculating-variations-by-week/m-p/1319913#M28482 2017-06-06T14:00:15Z Re: calculating variations by week https://community.qlik.com/t5/App-Development/calculating-variations-by-week/m-p/1319914#M28483 <HTML><HEAD></HEAD><BODY><P>Date and Product will be your dimensions here? Try this</P><P><STRONG>Aggr(Sum(Sales) - Above(Sum(Sales), Product, (Date, (Numeric)))</STRONG></P></BODY></HTML> Tue, 06 Jun 2017 14:02:10 GMT https://community.qlik.com/t5/App-Development/calculating-variations-by-week/m-p/1319914#M28483 sunny_talwar 2017-06-06T14:02:10Z Re: calculating variations by week https://community.qlik.com/t5/App-Development/calculating-variations-by-week/m-p/1319915#M28484 <HTML><HEAD></HEAD><BODY><P>It works Sunny <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thank you so much!</P></BODY></HTML> Thu, 08 Jun 2017 13:28:40 GMT https://community.qlik.com/t5/App-Development/calculating-variations-by-week/m-p/1319915#M28484 2017-06-08T13:28:40Z Re: calculating variations by week https://community.qlik.com/t5/App-Development/calculating-variations-by-week/m-p/1319916#M28485 <HTML><HEAD></HEAD><BODY><P>By the way, it has worked without the "numeric" field:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Aggr(Sum(Sales) - Above(Sum(Sales), Product, (Date))</STRONG></P></BODY></HTML> Thu, 08 Jun 2017 13:29:46 GMT https://community.qlik.com/t5/App-Development/calculating-variations-by-week/m-p/1319916#M28485 2017-06-08T13:29:46Z