Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
venkatg6759
Creator III
Creator III

Aggregation in straight table

Hello ,

Please find the attached qvw and try to help me to get this .

Firm No               Firm Name                Api                          Weighted%bad        

11                        royal                        ask_broker code            41.09%

How can i sum up the weighted% bad for the selection made and show only one result like above.

Thanks ,

4 Replies
venkatg6759
Creator III
Creator III
Author

can anyone help me on this

MayilVahanan

Hi

Remove weight from dimension,

Try like this in expression

= Sum(Aggr(sum({<eid=,security_type=,api=>}field_bad)/(sum({<eid=,security_type=,api=>}field_bad)+sum({<eid=,security_type=,api=>}field_good)) * Weight, FirmNum, FirmName, api, Weight))

Thanks & Regards,
Mayil Vahanan R
venkatg6759
Creator III
Creator III
Author

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 .

Example

firm name             no              Api                Weighted

                                                                       32%

Royal                   11              bid_exchange     10%

Royal                    11              bid_price            22%

Instead of getting this is there any possibility to get

Royal              11              32%

MayilVahanan

Hi

Its depend on your dimension, If you used Api in dimension, its show two rows.

Please reload and check the file

Thanks & Regards,
Mayil Vahanan R