topic Re: Click through in Bar Charts in QlikView

Click through in Bar Charts

Thu, 06 Oct 2011 11:20:56 GMT

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!

Re: Click through in Bar Charts

its_anandrjs — Thu, 06 Oct 2011 13:25:37 GMT

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

Re: Click through in Bar Charts

kji — Thu, 06 Oct 2011 13:52:53 GMT

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

Re: Click through in Bar Charts

gmarshall — Thu, 06 Oct 2011 15:04:52 GMT

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

Re: Click through in Bar Charts

its_anandrjs — Thu, 06 Oct 2011 15:19:02 GMT

Hi,

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

See the solution sheet.

HTH

Rgds
Anand