Filter on Expression Workaround for Bar Chart?

[#1]

I have a simple bar chart:

Dimension: MyTable.A

Expression: Sum({<MyTable.B = {'XYZ'}>} MyTable.C)

Underneath the bar chart, I have a straight table for details of MyTable.

When I "qlik" on a bar, I would like to see that particular bar's details in the straight table.  It shows the bar dimension I "qliked" on, but does not reflect MyTable.B = {'XYZ'}.

What is a good workaround to this problem?  Right now I have a second button that can be qlik'd to make the filter for B, but my user wants 1 click (value above bar should match value in straight table after 1 click).  Is there any way to use triggers/actions/macros for something like this?

[Gysbert_Wassenaar]

Use the same set modifier in the expressions in your straight table too. You can use a variable to store the set modifier so you only have to maintain it in one place. You can the use the variable in all the expressions that need it:

Variable vB_XYZ: {<MyTable.B = {'XYZ'}>}

Expression: sum( $(vB_XYZ) MyTable.C)