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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart Drill Down & Expressions

Hi, I have the following chart  :

chart_drill1.png

which has the following drill down dimensions :

chart_drill_dimensions.png

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

chart_drill_down two.png

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

1 Solution

Accepted Solutions
JonnyPoole
Former Employee
Former Employee

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.

Capture.PNG.png

Capture1.PNG.png

Capture2.PNG.png

View solution in original post

2 Replies
JonnyPoole
Former Employee
Former Employee

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.

Capture.PNG.png

Capture1.PNG.png

Capture2.PNG.png

Not applicable
Author

thank you for this - fits my requirements perfectly.