Click through in Bar Charts - Qlik Community

Report Inappropriate Content · ‎2011-10-06

Hello,

I'm sorry, this is probably a very easy question but I can't get my head around it. I think it might be solved by groups, but I'm not sure.

I want to create a bar chart, in my example, I've chosen 'favorite foods'. I'd like it so that it was a simple bar chart showing the three groups of food (ice cream, biscuits, cake) (as in graph 2), and then when the user clicked on the group, all the varities of that groupwere arrayed (graph 3). I can't get it to do this and I'm sure it must be possible!

Any help much appreciated!

its_anandrjs · ‎2011-10-06

Hi,

If by cyclic order / Drill Down if you use to create a table it looks good and the requirement that you want to achieve is display corretly.

See the sample file

Rgds

Anand

kji · ‎2011-10-06

Make a drill down group with first field Food Group, and second field Food Type, and use that as your dimension.

gmarshall · ‎2011-10-06

Take a look at tha attached which includes a screenshot of the set-up of the drill-down group.

its_anandrjs · ‎2011-10-06

Hi,

See the attached samle it will diaplay both Cyclic or Drill down group.

See the solution sheet.

HTH

Rgds
Anand