Three Different Total filters not working together
Hi Qlik Experts,
I have builded the table as shown below there are 3 measures and adding filters for them where
Following expressions are there for 3 button filters (Yes and No) :
Tot Ord Usage : If( Aggr(FABS(Sum({$<OrdCatKey={'12'}>} ([Tot Ord]))), [Order #],Material#,Order Dt,[Order Type]) > '500','Yes','No')
Tot Mat Usage : If( Aggr(FABS(Sum({$<OrdCatKey={'14'}>} ([Tot Ord]))), [Order #],Material#,Order Dt,[Order Type]) > '500','Yes','No')
Tot Ord Not Usage : If( Aggr(FABS(Sum({$<OrdCatKey={'16'}>} ([Tot Ord]))), [Order #],Material#,Order Dt,[Order Type]) > '500','Yes','No')
Requirement is User wants button for above filters, with Yes and No. When user clicks Tot Ord Usage = Yes, I should see row 2 and 3 (either value +ve or -ve), similarly it should work for other 2 filters also.
If user clicks for all 3 filters = Yes I should see only row 3.
I tried above formulas it works but it doesn't work correctly, when I click for one filter Yes it turns Yes for other 2 filters also I think it sees in column it sees some values meets the criteria. Is any way it brings result by row not by column.
Order # Order Type Material# Order Dt Tot Ord Usage Tot Mat Usage Tot Ord Not Usage
101 A1 1001 11/03/2019 450 350 1400
102 A2 1001 10/02/2018 -750 600 900
103 A1 1002 10/03/2018 900 500 100
104 A3 1003 09/02/2018 -100 -300 -550
105 A4 1004 03/02/2018 90 0 -23
Hope to get correct answer.
If any other approach or expression is there please let me know.
