Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Please close the thread by marking correct answer & give likes if you like the post.
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
Please close the thread by marking correct answer & give likes if you like the post.