topic Re: Chart Drill Down & Expressions in QlikView

Chart Drill Down & Expressions

Tue, 07 Oct 2014 12:45:01 GMT

Hi, I have the following chart :

which has the following drill down dimensions :

Is it possible when a 'bar' is selected that the following drill down is show using dimension 'SessionType' :

I'm having trouble getting the chart to flow 'back up to the' fist chart where the total is graphed...

many thanks for any help!

Tom

Re: Chart Drill Down & Expressions

JonnyPoole — Tue, 07 Oct 2014 15:22:24 GMT

Hi - i'm uncertain of the overall drill need.

The attached has an invisible text item over the chart that changes a variable. The chart only renders the 2nd dimension when the variable is set to 1. Clicking the chart again will reset.

Alternatively , you could use getselectedcount() to figure out if a month is selected and use that to conditionally show/hide the 2nd dimension.

Let me know if you think either could work for your use case.

Re: Chart Drill Down & Expressions

Wed, 08 Oct 2014 08:43:32 GMT

thank you for this - fits my requirements perfectly.