topic Re: Avg sum by quarter with set analysis in QlikView https://community.qlik.com/t5/QlikView/Avg-sum-by-quarter-with-set-analysis/m-p/871239#M304581 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><SPAN style="font-size: 8pt;">Avg(aggr(Sum({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Expense Type]</SPAN><SPAN style="font-size: 8pt;"> = {'Airfare'}&gt;} AmountSpend),</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Employee Name]</SPAN><SPAN style="font-size: 8pt;">, Quarter)) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">and let me know</SPAN></P></BODY></HTML> Tue, 14 Jul 2015 15:09:38 GMT alexandros17 2015-07-14T15:09:38Z Avg sum by quarter with set analysis https://community.qlik.com/t5/QlikView/Avg-sum-by-quarter-with-set-analysis/m-p/871238#M304580 <HTML><HEAD></HEAD><BODY><P>I am looking to calculate an expression that takes the average sum of Spend for (fieldname) [Expense Type] = {'Airfare'} by quarter aggregated by Employee Name. Right now I have what is shown below, but I am not sure where to incorporate quarter field. </P><P></P><P>Avg(aggr(Sum({&lt;[Expense Type] = {'Airfare'}&gt;} AmountSpend),[Employee Name]))</P></BODY></HTML> Tue, 14 Jul 2015 15:07:55 GMT https://community.qlik.com/t5/QlikView/Avg-sum-by-quarter-with-set-analysis/m-p/871238#M304580 2015-07-14T15:07:55Z Re: Avg sum by quarter with set analysis https://community.qlik.com/t5/QlikView/Avg-sum-by-quarter-with-set-analysis/m-p/871239#M304581 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><SPAN style="font-size: 8pt;">Avg(aggr(Sum({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Expense Type]</SPAN><SPAN style="font-size: 8pt;"> = {'Airfare'}&gt;} AmountSpend),</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Employee Name]</SPAN><SPAN style="font-size: 8pt;">, Quarter)) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">and let me know</SPAN></P></BODY></HTML> Tue, 14 Jul 2015 15:09:38 GMT https://community.qlik.com/t5/QlikView/Avg-sum-by-quarter-with-set-analysis/m-p/871239#M304581 alexandros17 2015-07-14T15:09:38Z Re: Avg sum by quarter with set analysis https://community.qlik.com/t5/QlikView/Avg-sum-by-quarter-with-set-analysis/m-p/871240#M304582 <HTML><HEAD></HEAD><BODY><P>If you are using Quarter as your dimension, I don't really see why you would quarter in the expression. Have you tried this with Quarter as your dimension? Is it not giving you the expected output?</P></BODY></HTML> Tue, 14 Jul 2015 15:09:53 GMT https://community.qlik.com/t5/QlikView/Avg-sum-by-quarter-with-set-analysis/m-p/871240#M304582 sunny_talwar 2015-07-14T15:09:53Z Re: Avg sum by quarter with set analysis https://community.qlik.com/t5/QlikView/Avg-sum-by-quarter-with-set-analysis/m-p/871241#M304583 <HTML><HEAD></HEAD><BODY><P>This document might help.</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4777">QlikView Technical Brief - AGGR</A></P></BODY></HTML> Tue, 14 Jul 2015 15:13:58 GMT https://community.qlik.com/t5/QlikView/Avg-sum-by-quarter-with-set-analysis/m-p/871241#M304583 ogster1974 2015-07-14T15:13:58Z Re: Avg sum by quarter with set analysis https://community.qlik.com/t5/QlikView/Avg-sum-by-quarter-with-set-analysis/m-p/871242#M304584 <HTML><HEAD></HEAD><BODY><P>It is within a straight table</P></BODY></HTML> Tue, 14 Jul 2015 15:23:37 GMT https://community.qlik.com/t5/QlikView/Avg-sum-by-quarter-with-set-analysis/m-p/871242#M304584 2015-07-14T15:23:37Z Re: Avg sum by quarter with set analysis https://community.qlik.com/t5/QlikView/Avg-sum-by-quarter-with-set-analysis/m-p/871243#M304585 <HTML><HEAD></HEAD><BODY><P>Thanks Alessandro, I want to say this worked but I am doing some QC checks first. </P></BODY></HTML> Tue, 14 Jul 2015 15:24:31 GMT https://community.qlik.com/t5/QlikView/Avg-sum-by-quarter-with-set-analysis/m-p/871243#M304585 2015-07-14T15:24:31Z