topic Aggregation in straight table in QlikView https://community.qlik.com/t5/QlikView/Aggregation-in-straight-table/m-p/495025#M552972 <HTML><HEAD></HEAD><BODY><P>Hello ,</P><P>Please find the attached <SPAN style="color: #ff6600;">qvw <SPAN style="color: #000000;">a</SPAN></SPAN>nd try to help me to get this .</P><P></P><P>Firm No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm Name&nbsp;&nbsp;&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weighted%bad&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; royal&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ask_broker code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 41.09%</P><P></P><P>How can i sum up the weighted% bad for the selection made and show only one result like above.</P><P></P><P>Thanks ,</P></BODY></HTML> Mon, 30 Sep 2013 13:23:28 GMT venkatg6759 2013-09-30T13:23:28Z Aggregation in straight table https://community.qlik.com/t5/QlikView/Aggregation-in-straight-table/m-p/495025#M552972 <HTML><HEAD></HEAD><BODY><P>Hello ,</P><P>Please find the attached <SPAN style="color: #ff6600;">qvw <SPAN style="color: #000000;">a</SPAN></SPAN>nd try to help me to get this .</P><P></P><P>Firm No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm Name&nbsp;&nbsp;&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weighted%bad&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; royal&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ask_broker code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 41.09%</P><P></P><P>How can i sum up the weighted% bad for the selection made and show only one result like above.</P><P></P><P>Thanks ,</P></BODY></HTML> Mon, 30 Sep 2013 13:23:28 GMT https://community.qlik.com/t5/QlikView/Aggregation-in-straight-table/m-p/495025#M552972 venkatg6759 2013-09-30T13:23:28Z Re: Aggregation in straight table https://community.qlik.com/t5/QlikView/Aggregation-in-straight-table/m-p/495026#M552973 <HTML><HEAD></HEAD><BODY><P>can anyone help me on this</P></BODY></HTML> Mon, 30 Sep 2013 13:56:38 GMT https://community.qlik.com/t5/QlikView/Aggregation-in-straight-table/m-p/495026#M552973 venkatg6759 2013-09-30T13:56:38Z Re: Aggregation in straight table https://community.qlik.com/t5/QlikView/Aggregation-in-straight-table/m-p/495027#M552974 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Remove weight from dimension,</P><P></P><P>Try like this in expression</P><P></P><P>= Sum(Aggr(sum({&lt;eid=,security_type=,api=&gt;}field_bad)/(sum({&lt;eid=,security_type=,api=&gt;}field_bad)+sum({&lt;eid=,security_type=,api=&gt;}field_good)) * Weight, FirmNum, FirmName, api, Weight))</P></BODY></HTML> Mon, 30 Sep 2013 17:17:12 GMT https://community.qlik.com/t5/QlikView/Aggregation-in-straight-table/m-p/495027#M552974 MayilVahanan 2013-09-30T17:17:12Z Re: Aggregation in straight table https://community.qlik.com/t5/QlikView/Aggregation-in-straight-table/m-p/495028#M552975 <HTML><HEAD></HEAD><BODY><P>For one selection it is working. Suppose if there are multiple selections made for Api. How can we get the total weighted in one line .</P><P>Example </P><P>firm name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; no&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; 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;&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;&nbsp;&nbsp; 32%</P><P>Royal&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bid_exchange&nbsp;&nbsp;&nbsp;&nbsp; 10%</P><P>Royal&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bid_price&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22%</P><P>Instead of getting this is there any possibility to get </P><P></P><P>Royal&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 32%</P></BODY></HTML> Mon, 30 Sep 2013 17:41:45 GMT https://community.qlik.com/t5/QlikView/Aggregation-in-straight-table/m-p/495028#M552975 venkatg6759 2013-09-30T17:41:45Z Re: Re: Aggregation in straight table https://community.qlik.com/t5/QlikView/Aggregation-in-straight-table/m-p/495029#M552976 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Its depend on your dimension, If you used Api in dimension, its show two rows.</P><P></P><P>Please reload and check the file</P></BODY></HTML> Mon, 30 Sep 2013 18:09:01 GMT https://community.qlik.com/t5/QlikView/Aggregation-in-straight-table/m-p/495029#M552976 MayilVahanan 2013-09-30T18:09:01Z