topic Re: Dynamic Cyclic Group drilldown based on selection in QlikView

Dynamic Cyclic Group drilldown based on selection

Fri, 31 Jan 2014 16:32:34 GMT

I was wondering if we have an option or workaround to dynamically drilldown in cyclic group based on selection.

Ex: I have a chart which gives Sales numbers for market hierarchy(region(4)>Area(10)>Market(52)>Submarket(185)). Now I have these Market levels in Cyclic group. Add it to a dimension in my chart.

When user makes a selection on Region(1/4) and Area(1/10)... the chart still shows numbers for Region.... I prefer to see the cyclic group to dynamically drill down to Market and still give option to user to toggle between Market levels.

Any suggestions and ideas?

Re: Dynamic Cyclic Group drilldown based on selection

juleshartley — Fri, 31 Jan 2014 16:39:07 GMT

So you want it to show a cyclic group but at the lower level selected? Do you still want to be able to cycle to 'region', if you have an area selected?

If so, you may have to set, for example, a variable = getselectedcount(region)=1. Use this to hide the 'top level' chart and unhide the area level chart and so on...

Re: Dynamic Cyclic Group drilldown based on selection

Fri, 31 Jan 2014 16:42:28 GMT

Hi Surya,

I do not know if I understood your problem correctly, but why do not you try to create a hierarchy group as a dimension instead of a cyclic group.

Re: Re: Dynamic Cyclic Group drilldown based on selection

Fri, 31 Jan 2014 16:54:22 GMT

Yes Initially my Combo chart shows trends for Group(Region>Area>Market>Submarket with Region as default)

Region	Sales13	Budget13	Variance13
Region1
Region3
Region2

When I Select region1 Still shows

Region	Sales13	Budget13	Variance13
Region1

I would like to have it drilldown to Area.... and when I make selection on Area should drill down to Market and soforth; And still toggle between Levels (Like if its now showing Area, should be able to drill down to Market or Submarket)

Area	Sales13	Budget13	Variance13
Area12
Area11
Area13

remember I'm using

Re: Re: Dynamic Cyclic Group drilldown based on selection

Fri, 31 Jan 2014 16:55:03 GMT

Hierarchy group as in Drilldown group??

Re: Dynamic Cyclic Group drilldown based on selection

Fri, 31 Jan 2014 16:58:33 GMT

Hi Surya,

Yes it is.

Re: Dynamic Cyclic Group drilldown based on selection

Fri, 31 Jan 2014 17:07:17 GMT

Again in Hierarchy group; User doesn't have option to toggle between Levels... once it drilled down cant come back to upper level unlike cyclic_groups

Re: Dynamic Cyclic Group drilldown based on selection

Fri, 31 Jan 2014 19:31:39 GMT

There are two ways to move up thru the Hierarchy group.

The first one is by dropping the selection on the higher hierarchy filter.

The second one is by click on the arrow next to the group column header.

If that is not the behavior you want, then I might misunderstood your point.