Show only Buyers where 75% of their vendors have shortages

[djbloiss]

I have a Qlikview Chart that shows Vendors for buyers only if the buyer has any shortages.  Now I would like to limit it to Buyers that only 75% of their vendors have shortages.  This is the expression field that I have:

Sum({$<SO_Closed={1}, [Order stocked out code]={''}>} [SO Order Quantity])-Sum({$<SO_Closed={1}, [Order stocked out code]={''}>} [Actual Quantity])

This shows all buyers and all their vendors.  I need to limit it to show only buyers that have more than 75% of their total vendors with any shortages.

I am new to qlikview and just getting used to these advanced abilities.

[djbloiss]

1. I fixed the title thank you

2) What do you mean what is the output?

The chart I am using is a Trellis pie chart so I can see one pie chart per Buyer and then shows all their vendors within their pie chart.

3) I know a buyer is in short supply if the formula I put in the OP is > 0

Sum({$<SO_Closed={1}, [Order stocked out code]={''}>} [SO Order Quantity])-Sum({$<SO_Closed={1}, [Order stocked out code]={''}>} [Actual Quantity])

4) Actual Quantity is the Quantity Received
SO Order Quantity is the Quantity that was originally on the Order

[YoussefBelloum]

Sorry but I feel that I'm in need to see the data..

Maybe stalwar1‌ can help at the first look..

[sunny_talwar]

I am not sure I understand also... may be OP can show an image of what he has in the chart and explain what he wants?