topic Re. :Re: Average in QlikView https://community.qlik.com/t5/QlikView/Average/m-p/160733#M34897 <HTML><HEAD></HEAD><BODY><P>Thanks, this was very helpful.</P></BODY></HTML> Tue, 25 May 2010 06:52:08 GMT 2010-05-25T06:52:08Z Average https://community.qlik.com/t5/QlikView/Average/m-p/160726#M34890 <HTML><HEAD></HEAD><BODY><P>Hi, I want to get 12% in the last of Avg but its giving 1%, is there any possibility to get 12% Avg in last.</P><P>Contacts Average</P><P>1 10%</P><P>2 2%</P><P>3 0</P><P>to</P><P>14 0</P><P>______</P><P>1%</P><P>Regards,</P><P>Khalid</P></BODY></HTML> Fri, 21 May 2010 08:46:38 GMT https://community.qlik.com/t5/QlikView/Average/m-p/160726#M34890 2010-05-21T08:46:38Z Average https://community.qlik.com/t5/QlikView/Average/m-p/160727#M34891 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Can you please post sample data in exceal with output whihc your expecting out that.</P><P>-Peterson<IMG alt="Geeked" src="http://community.qlik.com/emoticons/emotion-15.gif" /></P><P></P></BODY></HTML> Fri, 21 May 2010 08:53:40 GMT https://community.qlik.com/t5/QlikView/Average/m-p/160727#M34891 2010-05-21T08:53:40Z Average https://community.qlik.com/t5/QlikView/Average/m-p/160728#M34892 <HTML><HEAD></HEAD><BODY><P>Thanks so nice of you, I found its solution in Reference Manaual.</P><P>I have a question that can we do the expression given below through Set Analysis:</P><PRE style="background:white;">=Sum ( Aggr ( Sum ( Sales ) , Country , TransCCY ) )</PRE><P></P><P>Regards,</P></BODY></HTML> Fri, 21 May 2010 10:41:36 GMT https://community.qlik.com/t5/QlikView/Average/m-p/160728#M34892 2010-05-21T10:41:36Z Average https://community.qlik.com/t5/QlikView/Average/m-p/160729#M34893 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Major use of set analysis is different.</P><P>You are trying to sum up the sales with respect to country and TransCCY. There is no use of set analysis here.</P><P>-Peterson</P><P></P></BODY></HTML> Fri, 21 May 2010 10:51:26 GMT https://community.qlik.com/t5/QlikView/Average/m-p/160729#M34893 2010-05-21T10:51:26Z Re. :Re: Average https://community.qlik.com/t5/QlikView/Average/m-p/160730#M34894 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I don't understand what you want with this expression. Why don't you that :</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">sum(Sales)</PRE></BLOCKQUOTE><BR /><BR /> <P>Martin</P></BODY></HTML> Fri, 21 May 2010 10:53:27 GMT https://community.qlik.com/t5/QlikView/Average/m-p/160730#M34894 martin59 2010-05-21T10:53:27Z Average https://community.qlik.com/t5/QlikView/Average/m-p/160731#M34895 <HTML><HEAD></HEAD><BODY><P>Ok fine I understood, I found very good example of fuction aggr() in Reference Manaual when i clicked sum - of - rows totals in a Pivot Table . it shows chart Table with explanation and equation that kind of example I want for Set Analysis. Can you arrange a similar kind of example for Set Analysis in PDF format or an Application example.</P><P>I also checked in Reference Manaual it has good explanation of Set Analysis but it has not example like aggr() function.</P><P>Regards,</P><P>Khalid</P></BODY></HTML> Fri, 21 May 2010 11:07:19 GMT https://community.qlik.com/t5/QlikView/Average/m-p/160731#M34895 2010-05-21T11:07:19Z Re. :Re: Average https://community.qlik.com/t5/QlikView/Average/m-p/160732#M34896 <HTML><HEAD></HEAD><BODY><P>Look at the attachement and tell me if it's enough to understand.</P></BODY></HTML> Fri, 21 May 2010 14:49:12 GMT https://community.qlik.com/t5/QlikView/Average/m-p/160732#M34896 martin59 2010-05-21T14:49:12Z Re. :Re: Average https://community.qlik.com/t5/QlikView/Average/m-p/160733#M34897 <HTML><HEAD></HEAD><BODY><P>Thanks, this was very helpful.</P></BODY></HTML> Tue, 25 May 2010 06:52:08 GMT https://community.qlik.com/t5/QlikView/Average/m-p/160733#M34897 2010-05-25T06:52:08Z Re. :Re: Average https://community.qlik.com/t5/QlikView/Average/m-p/160734#M34898 <HTML><HEAD></HEAD><BODY><P>Hi,<BR /><BR />If I am using a 32bit QlikView Application and if I want to upgrade it to 64bit QlikView Application so what is the procedure for doing it. Do I have to pay it or have to purchase a new license for it? Please to let me know what is the policy of QlikView.<BR /><BR />Regards,<BR />Khalid</P></BODY></HTML> Tue, 25 May 2010 12:50:06 GMT https://community.qlik.com/t5/QlikView/Average/m-p/160734#M34898 2010-05-25T12:50:06Z Re. :Re: Re. :Re: Average https://community.qlik.com/t5/QlikView/Average/m-p/160735#M34899 <HTML><HEAD></HEAD><BODY><P>You have nothing to do, just download the 64-bit executable and install-it. It's the same licence, and same applications.</P><P>Martin</P></BODY></HTML> Tue, 25 May 2010 14:54:39 GMT https://community.qlik.com/t5/QlikView/Average/m-p/160735#M34899 martin59 2010-05-25T14:54:39Z