topic Re: Aggregation - Percentages Average in QlikView https://community.qlik.com/t5/QlikView/Aggregation-Percentages-Average/m-p/894442#M471059 <HTML><HEAD></HEAD><BODY><P>None has any idea about how to do this?</P><P>Thanks for your suggestions!</P></BODY></HTML> Sat, 18 Apr 2015 10:10:00 GMT 2015-04-18T10:10:00Z Aggregation - Percentages Average https://community.qlik.com/t5/QlikView/Aggregation-Percentages-Average/m-p/894441#M471058 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am in trouble and struggling with designing an expression which seems to me pretty simple, but in fact, I was able to write it down as expected.</P><P>Let me show you the scenario:</P><P></P><P><IMG alt="pivot.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/83352_pivot.png" style="height: 179px; width: 620px;" /></P><P></P><P>So, I have that for each date, I calculate the avg value and calculate a percentage of "improvement" of the value, following this formula: input-output/input*100.</P><P></P><P>This works fine when I have the Date Dimension (as in the picture). But I want to remove it and calculate an average of the formula (input-output/input*100). I do not want avg(input)-avg(output)/avg(input)*100, but the percentage average.</P><P></P><P>May you please help me to reach this goal? How can this be done?</P><P></P><P>Thanks in advance for your help!!&nbsp; </P></BODY></HTML> Fri, 10 Apr 2015 13:43:40 GMT https://community.qlik.com/t5/QlikView/Aggregation-Percentages-Average/m-p/894441#M471058 2015-04-10T13:43:40Z Re: Aggregation - Percentages Average https://community.qlik.com/t5/QlikView/Aggregation-Percentages-Average/m-p/894442#M471059 <HTML><HEAD></HEAD><BODY><P>None has any idea about how to do this?</P><P>Thanks for your suggestions!</P></BODY></HTML> Sat, 18 Apr 2015 10:10:00 GMT https://community.qlik.com/t5/QlikView/Aggregation-Percentages-Average/m-p/894442#M471059 2015-04-18T10:10:00Z Re: Aggregation - Percentages Average https://community.qlik.com/t5/QlikView/Aggregation-Percentages-Average/m-p/894443#M471060 <HTML><HEAD></HEAD><BODY><P>could you post your data?</P></BODY></HTML> Sat, 18 Apr 2015 13:31:03 GMT https://community.qlik.com/t5/QlikView/Aggregation-Percentages-Average/m-p/894443#M471060 maxgro 2015-04-18T13:31:03Z