Filter on Expression Workaround for Bar Chart?

Fri, 07 Jun 2013 16:02:35 GMT

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?

Re: Filter on Expression Workaround for Bar Chart?

Gysbert_Wassenaar — Fri, 07 Jun 2013 18:57:50 GMT

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)

topic Re: Filter on Expression Workaround for Bar Chart? in QlikView

Filter on Expression Workaround for Bar Chart?

Re: Filter on Expression Workaround for Bar Chart?