Hi! I want to know how to do the following: I have "Total Costs" per month in a bar chart and what I want to do is to click over a specific bar and display, in bars, the components of "Total Costs" for that specific month. For example, if the month is "May" and "Total Costs" is 100, when I click on "May" bar the chart should display "May" as month and (lets say) 2 bars which are "Variable Costs" and "Fixed Costs", which are the sum components of "Total Costs".
There are probably multiple ways to do it, but I don't think there is any built in functionality.
A quick way to handle it would be to create two charts and only show the relevant one. I've attached an example, when no month is selected, it displays the Total Costs per Month, when a month (or multiple) is selected, it shows the Cost Breakdown for the Selected Month.
I used this method, because in QlikView, clicking on an object in a chart will select it. When you click on a bar in the Total Costs chart, it will select that month in your document. Clear the selection to go back to the Total chart.
There are probably multiple ways to do it, but I don't think there is any built in functionality.
A quick way to handle it would be to create two charts and only show the relevant one. I've attached an example, when no month is selected, it displays the Total Costs per Month, when a month (or multiple) is selected, it shows the Cost Breakdown for the Selected Month.
I used this method, because in QlikView, clicking on an object in a chart will select it. When you click on a bar in the Total Costs chart, it will select that month in your document. Clear the selection to go back to the Total chart.
You could do it with a drill down group. That would work if you had a field like "Type of Cost" with values 'Fixed Costs' and 'Variable Costs', along with a field like "Cost" that you could sum. See attached.
