Filter Table object issues

[BrianDH]

Team, I am trying to filter a single QVD dataset that is being displayed with a table object.

If my Spend and Budget are both over 0 THEN I want to show only records that are 75% or greater.

=Aggr( if( SUM(jBH_AMOUNT_ACT + jBH_AMOUNT_GLA + jBH_AMOUNT_GLL + jBH_AMOUNT_GLQ + jBH_AMOUNT_GLR + jBH_AMOUNT_GLE + jBH_AMOUNT_PAY + jBH_AMOUNT_OTHER) > 0
AND SUM(jBH_AMOUNT_BUD) > 0

AND (SUM(jBH_AMOUNT_ACT + jBH_AMOUNT_GLA + jBH_AMOUNT_GLL + jBH_AMOUNT_GLQ + jBH_AMOUNT_GLR + jBH_AMOUNT_GLE + jBH_AMOUNT_PAY + jBH_AMOUNT_OTHER) *100 / SUM(jBH_AMOUNT_BUD) >=75.00
, MasterKey), MasterKey)

It has no effect on the rows that are displayed.

Suggestions

[Brett_Bleess · Accepted solution]

@BrianDH not sure if these are going to be helpful or not, but hopefully they might be:

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684

Regards,
Brett