Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
BrianDH
Creator II
Creator II

Filter Table object issues

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

Labels (2)
1 Solution

Accepted Solutions
Brett_Bleess
Support (Former)
Support (Former)

@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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

1 Reply
Brett_Bleess
Support (Former)
Support (Former)

@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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post