topic Re: Calculate average in pivottable in QlikView https://community.qlik.com/t5/QlikView/Calculate-average-in-pivottable/m-p/878673#M306759 <HTML><HEAD></HEAD><BODY><P>I suggest that you post a sample qvw to enable more accurate help.</P></BODY></HTML> Tue, 23 Jun 2015 07:02:04 GMT jonathandienst 2015-06-23T07:02:04Z Calculate average in pivottable https://community.qlik.com/t5/QlikView/Calculate-average-in-pivottable/m-p/878672#M306758 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>i want to calculate a average of a factor in a column of a pivottable, irrespective of users selection.</P><P>Actually i have this in the formula for the calculation:&nbsp; </P><P></P><P>avg(if(datum_test&gt;=vStartDatum and datum_test&lt;=vEndeDatum, fr_faktor1)) </P><P></P><P>If field "factor" in table "factor_ratenschema" not filled, use the factors of last 5 networkdays.<BR />Irrespective of users selection.</P><P></P><P>Hope somebody can help me.</P><P></P><P>Regards</P><P>Sabrina</P></BODY></HTML> Tue, 23 Jun 2015 06:58:16 GMT https://community.qlik.com/t5/QlikView/Calculate-average-in-pivottable/m-p/878672#M306758 2015-06-23T06:58:16Z Re: Calculate average in pivottable https://community.qlik.com/t5/QlikView/Calculate-average-in-pivottable/m-p/878673#M306759 <HTML><HEAD></HEAD><BODY><P>I suggest that you post a sample qvw to enable more accurate help.</P></BODY></HTML> Tue, 23 Jun 2015 07:02:04 GMT https://community.qlik.com/t5/QlikView/Calculate-average-in-pivottable/m-p/878673#M306759 jonathandienst 2015-06-23T07:02:04Z Re: Calculate average in pivottable https://community.qlik.com/t5/QlikView/Calculate-average-in-pivottable/m-p/878674#M306760 <HTML><HEAD></HEAD><BODY><P>Maybe it is because of the if statement. Replace it with set analysis (not very clear though):</P><P></P><P>avg({&lt;datum_test={"&gt;=$(vStartDatum)&lt;=$(vEndeDatum)"}&gt;} fr_faktor1)</P></BODY></HTML> Tue, 23 Jun 2015 07:03:08 GMT https://community.qlik.com/t5/QlikView/Calculate-average-in-pivottable/m-p/878674#M306760 giakoum 2015-06-23T07:03:08Z