topic Re: Straight table aggregation in QlikView https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484409#M553806 <HTML><HEAD></HEAD><BODY><P>I tried using pivot table but unable to get weighted% in that table .i used the same expression but weighted% was not working .</P></BODY></HTML> Thu, 26 Sep 2013 19:29:57 GMT venkatg6759 2013-09-26T19:29:57Z Straight table aggregation https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484400#M553797 <HTML><HEAD></HEAD><BODY><P>Hi Please go through the attached qvw and help me how can i get the table like this </P><P></P><P>Firm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; api&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weighted&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ask_broker&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 41.09% </P><P></P><P>Just one line for the desired selection made&nbsp; and also remove the N/A values and show the single line&nbsp; that is total .</P></BODY></HTML> Thu, 26 Sep 2013 15:41:57 GMT https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484400#M553797 venkatg6759 2013-09-26T15:41:57Z Re: Straight table aggregation https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484401#M553798 <HTML><HEAD></HEAD><BODY><P>can anyone help me on this </P></BODY></HTML> Thu, 26 Sep 2013 18:26:00 GMT https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484401#M553798 venkatg6759 2013-09-26T18:26:00Z Re: Straight table aggregation https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484402#M553799 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Can you provide a sample file?</P></BODY></HTML> Thu, 26 Sep 2013 18:33:46 GMT https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484402#M553799 MayilVahanan 2013-09-26T18:33:46Z Re: Straight table aggregation https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484403#M553800 <HTML><HEAD></HEAD><BODY><P>check the attachment need to get the total of weighted% based on selected field.Thanks in advance</P></BODY></HTML> Thu, 26 Sep 2013 18:39:32 GMT https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484403#M553800 venkatg6759 2013-09-26T18:39:32Z Re: Re: Straight table aggregation https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484404#M553801 <HTML><HEAD></HEAD><BODY><P>Maybe I'm not understanding your question but this works as you described.</P></BODY></HTML> Thu, 26 Sep 2013 18:40:27 GMT https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484404#M553801 Josh_Good 2013-09-26T18:40:27Z Re: Straight table aggregation https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484405#M553802 <HTML><HEAD></HEAD><BODY><P>i need to get the total of % weighted for the field.But i am gettting like this .</P><P>no name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field&nbsp;&nbsp;&nbsp; weighted%</P><P>&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff6600;">4%</SPAN></P><P>11&nbsp; tradelink&nbsp; security&nbsp;&nbsp; 2%</P><P>11&nbsp; trade link&nbsp; securtiy&nbsp;&nbsp;&nbsp; 2%.</P><P>But i need only one line like this</P><P><SPAN style="color: #ff0000;">11&nbsp; tradelink&nbsp;&nbsp; security&nbsp;&nbsp;&nbsp; 4%</SPAN></P><P></P><P>Thanks ,</P></BODY></HTML> Thu, 26 Sep 2013 18:50:11 GMT https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484405#M553802 venkatg6759 2013-09-26T18:50:11Z Re: Straight table aggregation https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484406#M553803 <HTML><HEAD></HEAD><BODY><P>I believe that is what I am showing in the QVW.&nbsp; What is wrong with my solution?</P></BODY></HTML> Thu, 26 Sep 2013 19:21:05 GMT https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484406#M553803 Josh_Good 2013-09-26T19:21:05Z Re: Straight table aggregation https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484407#M553804 <HTML><HEAD></HEAD><BODY><P>Why don't you use a Pivot Table ?</P></BODY></HTML> Thu, 26 Sep 2013 19:25:49 GMT https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484407#M553804 Anonymous 2013-09-26T19:25:49Z Re: Straight table aggregation https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484408#M553805 <HTML><HEAD></HEAD><BODY><P>According to your qvw weighted % is loaded inline but here i am having set analysis expression for that .</P><P>Thanks</P></BODY></HTML> Thu, 26 Sep 2013 19:28:54 GMT https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484408#M553805 venkatg6759 2013-09-26T19:28:54Z Re: Straight table aggregation https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484409#M553806 <HTML><HEAD></HEAD><BODY><P>I tried using pivot table but unable to get weighted% in that table .i used the same expression but weighted% was not working .</P></BODY></HTML> Thu, 26 Sep 2013 19:29:57 GMT https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484409#M553806 venkatg6759 2013-09-26T19:29:57Z Re: Straight table aggregation https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484410#M553807 <HTML><HEAD></HEAD><BODY><P>I think that is needed to see your .QVD.</P><P>Regards</P></BODY></HTML> Thu, 26 Sep 2013 19:33:16 GMT https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484410#M553807 Anonymous 2013-09-26T19:33:16Z Re: Straight table aggregation https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484411#M553808 <HTML><HEAD></HEAD><BODY><P>I meant your .qvw.</P></BODY></HTML> Thu, 26 Sep 2013 19:33:47 GMT https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484411#M553808 Anonymous 2013-09-26T19:33:47Z Re: Re: Straight table aggregation https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484412#M553809 <HTML><HEAD></HEAD><BODY><P>I cannot share my qvw instead i can give you excel attachment.How the calculations are performed .Please find the attachment</P></BODY></HTML> Thu, 26 Sep 2013 19:38:13 GMT https://community.qlik.com/t5/QlikView/Straight-table-aggregation/m-p/484412#M553809 venkatg6759 2013-09-26T19:38:13Z