topic Rangeavg/rangesum not working with second dimension in QlikView https://community.qlik.com/t5/QlikView/Rangeavg-rangesum-not-working-with-second-dimension/m-p/212560#M66508 <HTML><HEAD></HEAD><BODY><P>Hi, I partially did. As long as I don't need to do divitions against the rolling average, the use of the Total qualifier fixed this.</P></BODY></HTML> Fri, 04 Jun 2010 07:47:39 GMT tseebach 2010-06-04T07:47:39Z Rangeavg/rangesum not working with second dimension https://community.qlik.com/t5/QlikView/Rangeavg-rangesum-not-working-with-second-dimension/m-p/212558#M66506 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I've used the rangesum to calculate a running 12 months sales average. Which works nicely, but when adding a secondary dimension, to split data between company the running average fails to return the right values.</P><P>Please look at the attached file, the top chart has 2 dimension, the botton only 1. If you remove the second dimension in the top graph you will see it calculates correctly again.</P><P>Am I totally missing something? Thanks in advance.</P><P><A href="http://dl.dropbox.com/u/1773255/testRollingAverage.qvw">http://dl.dropbox.com/u/1773255/testRollingAverage.qvw</A></P><P></P></BODY></HTML> Thu, 14 Jan 2010 17:14:01 GMT https://community.qlik.com/t5/QlikView/Rangeavg-rangesum-not-working-with-second-dimension/m-p/212558#M66506 tseebach 2010-01-14T17:14:01Z Rangeavg/rangesum not working with second dimension https://community.qlik.com/t5/QlikView/Rangeavg-rangesum-not-working-with-second-dimension/m-p/212559#M66507 <HTML><HEAD></HEAD><BODY><P>Did you resolve this? I am having the same trouble.</P></BODY></HTML> Thu, 03 Jun 2010 23:02:01 GMT https://community.qlik.com/t5/QlikView/Rangeavg-rangesum-not-working-with-second-dimension/m-p/212559#M66507 2010-06-03T23:02:01Z Rangeavg/rangesum not working with second dimension https://community.qlik.com/t5/QlikView/Rangeavg-rangesum-not-working-with-second-dimension/m-p/212560#M66508 <HTML><HEAD></HEAD><BODY><P>Hi, I partially did. As long as I don't need to do divitions against the rolling average, the use of the Total qualifier fixed this.</P></BODY></HTML> Fri, 04 Jun 2010 07:47:39 GMT https://community.qlik.com/t5/QlikView/Rangeavg-rangesum-not-working-with-second-dimension/m-p/212560#M66508 tseebach 2010-06-04T07:47:39Z