Nested Bar Chart

[Anonymous]

I have two charts, one for displaying the main category values like the following one.

(Chart 1)

Here, Alphabet is associated with values A,B,C,D,E.... Numbers are associated with values 1,2,3...

The chart for sub-category will be like

(Chart 2)

So, if the user clicks 'Alphabet' in Chart 1, Chart 2 should be shown. Instead qlikview just shows the Alphabet bar.

For changing the Dimensions we can use Cyclic groups, but the user somehow is not interested in having a Cyclic group, instead this needs to be achieved in a single click. ie When user Clicks Alphabet then the chart with A,B,C... should be shown.

Is there a way to achieve this in a single chart? Also, is there a way to return to the previous chart? ie if user wants to go back to Chart 1  from Chart 2, how can that be achieved?

[lironbaram · Accepted solution]

hi

yes you just need to create a drill down group

so as soon as the user clicks on alphabet

the dimension will change to sub-category