topic QTY Variance in QlikView https://community.qlik.com/t5/QlikView/QTY-Variance/m-p/160510#M34760 <HTML><HEAD></HEAD><BODY><P>anyone at all?</P></BODY></HTML> Wed, 27 Oct 2010 12:26:53 GMT 2010-10-27T12:26:53Z QTY Variance https://community.qlik.com/t5/QlikView/QTY-Variance/m-p/160508#M34758 <HTML><HEAD></HEAD><BODY><P>Hey guys.</P><P></P><P>I have a table i need to see the changes in Quantity over a week. I only have a weeks worth of data. This is my current formula:</P><P></P><P>sum({$&lt;Day={$(=Only()-1)}&gt;}(QtySold))</P><P></P><P>I set it as an expression as well as sum(QtySold) to show the current days Qty. I have Days as a dimension. The formula given above is not working. Can anyone help on this and maybe supply a variance expression formula also?</P><P></P><P>Thanks you so much.</P></BODY></HTML> Wed, 27 Oct 2010 08:07:21 GMT https://community.qlik.com/t5/QlikView/QTY-Variance/m-p/160508#M34758 2010-10-27T08:07:21Z QTY Variance https://community.qlik.com/t5/QlikView/QTY-Variance/m-p/160509#M34759 <HTML><HEAD></HEAD><BODY><P>anyone got any ideas please?</P></BODY></HTML> Wed, 27 Oct 2010 09:16:02 GMT https://community.qlik.com/t5/QlikView/QTY-Variance/m-p/160509#M34759 2010-10-27T09:16:02Z QTY Variance https://community.qlik.com/t5/QlikView/QTY-Variance/m-p/160510#M34760 <HTML><HEAD></HEAD><BODY><P>anyone at all?</P></BODY></HTML> Wed, 27 Oct 2010 12:26:53 GMT https://community.qlik.com/t5/QlikView/QTY-Variance/m-p/160510#M34760 2010-10-27T12:26:53Z QTY Variance https://community.qlik.com/t5/QlikView/QTY-Variance/m-p/160511#M34761 <HTML><HEAD></HEAD><BODY><P>You can't do it with set analysis because the set is only calculated once for your entire chart, not once per row in your chart.</P><P>I recommend handling it with an AsOf table to connect everything together. See attached example for comparing years.</P></BODY></HTML> Wed, 27 Oct 2010 21:41:32 GMT https://community.qlik.com/t5/QlikView/QTY-Variance/m-p/160511#M34761 johnw 2010-10-27T21:41:32Z QTY Variance https://community.qlik.com/t5/QlikView/QTY-Variance/m-p/160512#M34762 <HTML><HEAD></HEAD><BODY><P>Thanks so much man. Im going to look into it today.</P></BODY></HTML> Thu, 28 Oct 2010 06:55:11 GMT https://community.qlik.com/t5/QlikView/QTY-Variance/m-p/160512#M34762 2010-10-28T06:55:11Z