topic Re: Avg of Top 10 values in QlikView https://community.qlik.com/t5/QlikView/Avg-of-Top-10-values/m-p/693323#M537916 <HTML><HEAD></HEAD><BODY><P>=avg({&lt;screenname={"=rank(sum({&lt;sentiment={'Positive'}&gt;}klout_count))&lt;11"}, sentiment={'Positive'}&gt;}klout_count)</P></BODY></HTML> Thu, 25 Sep 2014 12:19:20 GMT Gysbert_Wassenaar 2014-09-25T12:19:20Z Avg of Top 10 values https://community.qlik.com/t5/QlikView/Avg-of-Top-10-values/m-p/693322#M537915 <HTML><HEAD></HEAD><BODY><P>Hi all ,<A href="https://community.qlik.com/qlik-users/96544">Gysbert Wassenaar</A> </P><P></P><P>I am struck with a task. All I want is to show the&nbsp; Avg of top 10 score values whose sentiment is positive in a text box.</P><P>In other words , I have Klout count&nbsp; and sentiment . For sentiment 'Postive' , I need to calculate average KLOUT value of top 10 Klout counts.</P><P></P><P>Sample data is attached.</P><P></P><P>Any help would be appreciated.</P><P></P><P>Thanks in Advance</P><P></P><P>Best Regards,</P><P>Susvith</P></BODY></HTML> Thu, 25 Sep 2014 10:29:28 GMT https://community.qlik.com/t5/QlikView/Avg-of-Top-10-values/m-p/693322#M537915 2014-09-25T10:29:28Z Re: Avg of Top 10 values https://community.qlik.com/t5/QlikView/Avg-of-Top-10-values/m-p/693323#M537916 <HTML><HEAD></HEAD><BODY><P>=avg({&lt;screenname={"=rank(sum({&lt;sentiment={'Positive'}&gt;}klout_count))&lt;11"}, sentiment={'Positive'}&gt;}klout_count)</P></BODY></HTML> Thu, 25 Sep 2014 12:19:20 GMT https://community.qlik.com/t5/QlikView/Avg-of-Top-10-values/m-p/693323#M537916 Gysbert_Wassenaar 2014-09-25T12:19:20Z Re: Avg of Top 10 values https://community.qlik.com/t5/QlikView/Avg-of-Top-10-values/m-p/693324#M537917 <HTML><HEAD></HEAD><BODY><P>Thank u so much Brother.</P><P></P><P></P><P>Thanks a ton man</P></BODY></HTML> Thu, 25 Sep 2014 12:34:52 GMT https://community.qlik.com/t5/QlikView/Avg-of-Top-10-values/m-p/693324#M537917 2014-09-25T12:34:52Z