topic XYZ analysis: how? in QlikView https://community.qlik.com/t5/QlikView/XYZ-analysis-how/m-p/416648#M154878 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I have table with fields:</P><P>Date</P><P>Product</P><P>Cost</P><P></P><P>I want to develop XYZ analisys by Product. </P><P>Time unit is MONTH.</P><P>In XYZ there is formula:</P><P>SUM (sqr ( AVGbyMonth (CostOfProduct) - AVG&nbsp; (CostOfProduct))).</P><P>How I can get the AVGbyMonth (CostOfProduct)?</P><P>I tried to generate calendar and join my table and calendar table (field Month) - my computer is 100% busy for ling time (I think, I do something wrong).</P><P>Please help me!</P><P>And if you can share to me your examples of XYZ analysis - do it please.</P><P>Thank you!</P></BODY></HTML> Wed, 03 Apr 2013 08:55:24 GMT 2013-04-03T08:55:24Z XYZ analysis: how? https://community.qlik.com/t5/QlikView/XYZ-analysis-how/m-p/416648#M154878 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I have table with fields:</P><P>Date</P><P>Product</P><P>Cost</P><P></P><P>I want to develop XYZ analisys by Product. </P><P>Time unit is MONTH.</P><P>In XYZ there is formula:</P><P>SUM (sqr ( AVGbyMonth (CostOfProduct) - AVG&nbsp; (CostOfProduct))).</P><P>How I can get the AVGbyMonth (CostOfProduct)?</P><P>I tried to generate calendar and join my table and calendar table (field Month) - my computer is 100% busy for ling time (I think, I do something wrong).</P><P>Please help me!</P><P>And if you can share to me your examples of XYZ analysis - do it please.</P><P>Thank you!</P></BODY></HTML> Wed, 03 Apr 2013 08:55:24 GMT https://community.qlik.com/t5/QlikView/XYZ-analysis-how/m-p/416648#M154878 2013-04-03T08:55:24Z