topic Re: Aggregation problem ... in QlikView https://community.qlik.com/t5/QlikView/Aggregation-problem/m-p/307495#M113546 <HTML><HEAD></HEAD><BODY><P>see the attached file </P><P></P><P>hope this helps</P></BODY></HTML> Mon, 03 Oct 2011 08:32:28 GMT SunilChauhan 2011-10-03T08:32:28Z Aggregation problem ... https://community.qlik.com/t5/QlikView/Aggregation-problem/m-p/307493#M113544 <HTML><HEAD></HEAD><BODY><P>Hi, please refer to the following data set and the formula to calculate the revenue. Attached herewith is my Qlikview application. My problem is when i selecting a company, there is no any output. Kindly please help me to fix the bug. Thanks much.</P><P> <BR />YEAR 2011<BR />-----------------</P><P>company_code&nbsp;&nbsp; fiscal_year&nbsp;&nbsp;&nbsp;&nbsp; revenue<BR />1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10/20 = 0.5<BR />2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30/40 = 0.75<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50/60 = 0.83</P><P>Average revenue for year 2011 = (0.5 + 0.75 + 0.83) / 3 = 0.69</P><P><BR />YEAR 2010<BR />----------------</P><P>company_code&nbsp;&nbsp;&nbsp; fiscal_year&nbsp;&nbsp;&nbsp;&nbsp; revenue<BR />1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 70/80 = 0.88<BR />2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90/100 = 0.9<BR />3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 110/120 = 0.92</P><P>Average revenue for year 2010 = (0.88 + 0.9 + 0.92) / 3 = 0.9</P></BODY></HTML> Mon, 03 Oct 2011 08:02:30 GMT https://community.qlik.com/t5/QlikView/Aggregation-problem/m-p/307493#M113544 2011-10-03T08:02:30Z Re: Aggregation problem ... https://community.qlik.com/t5/QlikView/Aggregation-problem/m-p/307494#M113545 <HTML><HEAD></HEAD><BODY><P> hei </P><P> i made two changes one i used the e() function in your set analysis </P><P>seconed you need to put yuor set analysis expression in the avg function also</P><P></P><P></P><P>see attach example</P></BODY></HTML> Mon, 03 Oct 2011 08:17:49 GMT https://community.qlik.com/t5/QlikView/Aggregation-problem/m-p/307494#M113545 lironbaram 2011-10-03T08:17:49Z Re: Aggregation problem ... https://community.qlik.com/t5/QlikView/Aggregation-problem/m-p/307495#M113546 <HTML><HEAD></HEAD><BODY><P>see the attached file </P><P></P><P>hope this helps</P></BODY></HTML> Mon, 03 Oct 2011 08:32:28 GMT https://community.qlik.com/t5/QlikView/Aggregation-problem/m-p/307495#M113546 SunilChauhan 2011-10-03T08:32:28Z Aggregation problem ... https://community.qlik.com/t5/QlikView/Aggregation-problem/m-p/307496#M113547 <HTML><HEAD></HEAD><BODY><P>Hi Liron, you are brilliant! Thanks so much! Would you mind to explain to me why it is needed to put the set analysis in the AVG function? And why only the set analysis for nominator needs to be put in the AVG function? Thanks.</P></BODY></HTML> Mon, 03 Oct 2011 08:49:52 GMT https://community.qlik.com/t5/QlikView/Aggregation-problem/m-p/307496#M113547 2011-10-03T08:49:52Z Aggregation problem ... https://community.qlik.com/t5/QlikView/Aggregation-problem/m-p/307497#M113548 <HTML><HEAD></HEAD><BODY><P> Thank you Sunil <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 03 Oct 2011 08:50:23 GMT https://community.qlik.com/t5/QlikView/Aggregation-problem/m-p/307497#M113548 2011-10-03T08:50:23Z Re: Aggregation problem ... https://community.qlik.com/t5/QlikView/Aggregation-problem/m-p/307498#M113549 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I'm confused w the solution Liron &amp; Sunil, plsto see attach ...</P><P>What is ok? </P><P>Very thx, Luis</P></BODY></HTML> Mon, 03 Oct 2011 10:43:39 GMT https://community.qlik.com/t5/QlikView/Aggregation-problem/m-p/307498#M113549 llauses243 2011-10-03T10:43:39Z