Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Intersection of selected Items

Hi,

Please take a look at the sample app. Here table 2 should show sum of quantities for those PartNames who have "all" the colors selected by the user from the PartColor list box.  For example, if user selects blue and brown colors, then it should show 44 as this would be the sum of quantities for all PartNames who have both blue and brown quantities. So, from the inline input table below, the items with an X in front of them should be selected and summed up by the chart expression:

A,blue,3     X

B,blue,10   - this value should not be in the sum since item B does not have a Brown color

A,green,4

A,red,4

B,green,2

B,red,7

B,green,9

A,brown,2     X

C,blue,8     X

D,blue,11     X

C,red,5

D,green,6

D,brown,12     X

C,brown,8     X

0 Replies