topic XYZ-analysis in QlikView https://community.qlik.com/t5/QlikView/XYZ-analysis/m-p/416438#M154817 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I am a beginner in QV.</P><P>I have a problem in realisation of XYZ-analysis.</P><P>My XYZ formula:</P><P>DeviationValue = r / AveragePurchaseValue</P><P>r = sqrt ( SUM ( sqr (AveragePurchaseValueByMonth - AveragePurchaseValue)) / NumberOfMonths )</P><P>Please, help me get AveragePurchaseValueByMonth and NumberOfMonths values. count (Month) gave me result for months with product was purchased, period when has no purchasing the product, not counting.</P><P>And (if it is possible) share to me examples of XYZ-analysis in QV.</P><P>Thanks!</P></BODY></HTML> Wed, 03 Apr 2013 07:42:38 GMT 2013-04-03T07:42:38Z XYZ-analysis https://community.qlik.com/t5/QlikView/XYZ-analysis/m-p/416438#M154817 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I am a beginner in QV.</P><P>I have a problem in realisation of XYZ-analysis.</P><P>My XYZ formula:</P><P>DeviationValue = r / AveragePurchaseValue</P><P>r = sqrt ( SUM ( sqr (AveragePurchaseValueByMonth - AveragePurchaseValue)) / NumberOfMonths )</P><P>Please, help me get AveragePurchaseValueByMonth and NumberOfMonths values. count (Month) gave me result for months with product was purchased, period when has no purchasing the product, not counting.</P><P>And (if it is possible) share to me examples of XYZ-analysis in QV.</P><P>Thanks!</P></BODY></HTML> Wed, 03 Apr 2013 07:42:38 GMT https://community.qlik.com/t5/QlikView/XYZ-analysis/m-p/416438#M154817 2013-04-03T07:42:38Z