topic Display Average Column in QlikView https://community.qlik.com/t5/QlikView/Display-Average-Column/m-p/702910#M253611 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I have this pivot presented:</P><P></P><P>Period&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; James&nbsp;&nbsp;&nbsp;&nbsp; David&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Daniel</P><P></P><P>2012/1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>2012/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>2012/3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400</P><P></P><P>I want to present an average column for each month (as last column)</P><P></P><P>I tried adding another expression it adds this column for each salesman.</P><P></P><P>how do i do it?</P></BODY></HTML> Sun, 03 Aug 2014 06:21:25 GMT 2014-08-03T06:21:25Z Display Average Column https://community.qlik.com/t5/QlikView/Display-Average-Column/m-p/702910#M253611 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I have this pivot presented:</P><P></P><P>Period&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; James&nbsp;&nbsp;&nbsp;&nbsp; David&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Daniel</P><P></P><P>2012/1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>2012/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>2012/3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400</P><P></P><P>I want to present an average column for each month (as last column)</P><P></P><P>I tried adding another expression it adds this column for each salesman.</P><P></P><P>how do i do it?</P></BODY></HTML> Sun, 03 Aug 2014 06:21:25 GMT https://community.qlik.com/t5/QlikView/Display-Average-Column/m-p/702910#M253611 2014-08-03T06:21:25Z Re: Display Average Column https://community.qlik.com/t5/QlikView/Display-Average-Column/m-p/702911#M253612 <HTML><HEAD></HEAD><BODY><P>hi there,</P><P></P><P>hope this helps you</P></BODY></HTML> Sun, 03 Aug 2014 06:59:34 GMT https://community.qlik.com/t5/QlikView/Display-Average-Column/m-p/702911#M253612 preminqlik 2014-08-03T06:59:34Z Re: Display Average Column https://community.qlik.com/t5/QlikView/Display-Average-Column/m-p/702912#M253613 <HTML><HEAD></HEAD><BODY><P>Use expression like: If(dimensionality()=1, Avg(YourMeasurefield), Sum( YourMeasurefield)</P><P>Then enable partial sum in the presentation tab for second dimension. PFA</P></BODY></HTML> Sun, 03 Aug 2014 07:06:57 GMT https://community.qlik.com/t5/QlikView/Display-Average-Column/m-p/702912#M253613 tresB 2014-08-03T07:06:57Z Re: Re: Display Average Column https://community.qlik.com/t5/QlikView/Display-Average-Column/m-p/702913#M253614 <HTML><HEAD></HEAD><BODY><P>Results come up wrong...</P><P><IMG alt="Untitled.png" class="jive-image" height="227" src="https://community.qlik.com/legacyfs/online/63601_Untitled.png" style="width: 777.5690607734807px; height: 227px;" width="778" /></P><P>Why?</P></BODY></HTML> Sun, 03 Aug 2014 15:45:45 GMT https://community.qlik.com/t5/QlikView/Display-Average-Column/m-p/702913#M253614 2014-08-03T15:45:45Z