topic Re: Pivot Average, ignore dimensions. in QlikView https://community.qlik.com/t5/QlikView/Pivot-Average-ignore-dimensions/m-p/389781#M145433 <HTML><HEAD></HEAD><BODY><P>Plz provide a sample,</P></BODY></HTML> Tue, 21 May 2013 08:30:10 GMT sujeetsingh 2013-05-21T08:30:10Z Pivot Average, ignore dimensions. https://community.qlik.com/t5/QlikView/Pivot-Average-ignore-dimensions/m-p/389780#M145432 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table with average process times per monthday (1-31), dimension STARTTIME_DAY. I want one additional column to display the daily average over the whole set. </P><P></P><P>Daily average is computed as follows:</P><P>=time(avg(STARTTIME-ENDTIME))</P><P></P><P>I have tried </P><P>=time(avg({&lt;STARTTIME_DAY=&gt;}STARTTIME-ENDTIME))</P><P>but this will return an additional column for each day, while I want a column similar to partial sum.</P><P></P><P>Any ideas will be appreciated.</P></BODY></HTML> Tue, 21 May 2013 08:23:19 GMT https://community.qlik.com/t5/QlikView/Pivot-Average-ignore-dimensions/m-p/389780#M145432 2013-05-21T08:23:19Z Re: Pivot Average, ignore dimensions. https://community.qlik.com/t5/QlikView/Pivot-Average-ignore-dimensions/m-p/389781#M145433 <HTML><HEAD></HEAD><BODY><P>Plz provide a sample,</P></BODY></HTML> Tue, 21 May 2013 08:30:10 GMT https://community.qlik.com/t5/QlikView/Pivot-Average-ignore-dimensions/m-p/389781#M145433 sujeetsingh 2013-05-21T08:30:10Z Re: Pivot Average, ignore dimensions. https://community.qlik.com/t5/QlikView/Pivot-Average-ignore-dimensions/m-p/389782#M145434 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>unfortunately I can't share the Qlikview file but here's an example of what I want in Excel.</P><P></P><P>Stupid, in the total column Qlikview automatically computes the expression over the complete dimension.</P></BODY></HTML> Tue, 21 May 2013 09:37:00 GMT https://community.qlik.com/t5/QlikView/Pivot-Average-ignore-dimensions/m-p/389782#M145434 2013-05-21T09:37:00Z