topic Re: Average and count in pivot table? in QlikView https://community.qlik.com/t5/QlikView/Average-and-count-in-pivot-table/m-p/238486#M89348 <HTML><HEAD></HEAD><BODY><P>It is possible.&nbsp; You'll better off if you ask your own question, and give at least some details.</P><P>A generic example:</P><P>if</P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Dimensionality</SPAN><SPAN style="font-size: 8pt;">()=</SPAN><SPAN style="color: #363636; font-size: 8pt;">0</SPAN><SPAN style="font-size: 8pt;">,<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">&lt;expression for avegarge&gt; </SPAN><SPAN style="font-size: 8pt;">&amp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">chr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #363636; font-size: 8pt;">13</SPAN><SPAN style="font-size: 8pt;">)&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">chr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #363636; font-size: 8pt;">10</SPAN><SPAN style="font-size: 8pt;">) &amp; &lt;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">expression for count&gt;</SPAN><SPAN style="font-size: 8pt;"><BR /> ,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">&lt;your "major" expression&gt;</SPAN><SPAN style="font-size: 8pt;"><BR /> ) </SPAN></P><P><SPAN style="font-size: 8pt;">And, use multiline settings in Presentation. </SPAN></P></BODY></HTML> Thu, 16 May 2013 17:03:24 GMT Anonymous 2013-05-16T17:03:24Z Average and count in pivot table? https://community.qlik.com/t5/QlikView/Average-and-count-in-pivot-table/m-p/238483#M89345 <HTML><HEAD></HEAD><BODY><P>is it possible to have a average and a count in the total line (2lines)?</P><P></P></BODY></HTML> Sun, 14 Feb 2010 12:15:20 GMT https://community.qlik.com/t5/QlikView/Average-and-count-in-pivot-table/m-p/238483#M89345 2010-02-14T12:15:20Z Average and count in pivot table? https://community.qlik.com/t5/QlikView/Average-and-count-in-pivot-table/m-p/238484#M89346 <HTML><HEAD></HEAD><BODY><P>Have you any update on this? I have just the same question and no answer...</P></BODY></HTML> Fri, 08 Apr 2011 14:11:58 GMT https://community.qlik.com/t5/QlikView/Average-and-count-in-pivot-table/m-p/238484#M89346 2011-04-08T14:11:58Z Re: Average and count in pivot table? https://community.qlik.com/t5/QlikView/Average-and-count-in-pivot-table/m-p/238485#M89347 <HTML><HEAD></HEAD><BODY><P>Still nothing? </P></BODY></HTML> Thu, 16 May 2013 16:51:38 GMT https://community.qlik.com/t5/QlikView/Average-and-count-in-pivot-table/m-p/238485#M89347 2013-05-16T16:51:38Z Re: Average and count in pivot table? https://community.qlik.com/t5/QlikView/Average-and-count-in-pivot-table/m-p/238486#M89348 <HTML><HEAD></HEAD><BODY><P>It is possible.&nbsp; You'll better off if you ask your own question, and give at least some details.</P><P>A generic example:</P><P>if</P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Dimensionality</SPAN><SPAN style="font-size: 8pt;">()=</SPAN><SPAN style="color: #363636; font-size: 8pt;">0</SPAN><SPAN style="font-size: 8pt;">,<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">&lt;expression for avegarge&gt; </SPAN><SPAN style="font-size: 8pt;">&amp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">chr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #363636; font-size: 8pt;">13</SPAN><SPAN style="font-size: 8pt;">)&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">chr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #363636; font-size: 8pt;">10</SPAN><SPAN style="font-size: 8pt;">) &amp; &lt;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">expression for count&gt;</SPAN><SPAN style="font-size: 8pt;"><BR /> ,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">&lt;your "major" expression&gt;</SPAN><SPAN style="font-size: 8pt;"><BR /> ) </SPAN></P><P><SPAN style="font-size: 8pt;">And, use multiline settings in Presentation. </SPAN></P></BODY></HTML> Thu, 16 May 2013 17:03:24 GMT https://community.qlik.com/t5/QlikView/Average-and-count-in-pivot-table/m-p/238486#M89348 Anonymous 2013-05-16T17:03:24Z Re: Average and count in pivot table? https://community.qlik.com/t5/QlikView/Average-and-count-in-pivot-table/m-p/238487#M89349 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Thu, 16 May 2013 17:53:51 GMT https://community.qlik.com/t5/QlikView/Average-and-count-in-pivot-table/m-p/238487#M89349 2013-05-16T17:53:51Z