Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)