Is it possible to make a cyclic with drill down function?

[#1]

I have made a cyclic group (c1,c2,c3) and wanted to be able to drill down in each cyclic level. How do I do that? I am new to QlikView and am thinking if the "enable conditional" in the "dimension" tab is related to my question. Thanks a lot!

[stevedark]

You can't blend Cyclic and Drill in a single group natively, but you can have expressions in your Cycle Group, so you could have an expression like this one that I have used on my Dynamic Date Dimension:

QlikView App: Dynamic Date Dimension

You could have a number of different Dynamic Dimensions in a single Cycle group.

Hope that helps,

Steve Dark

[#3]

Thank you for your quick response.

But I still want to allow the user to switch between views using cyclic group.

For example (please see attached), I have created a cyclic group that shows either "category" or "agent". When I click the bar in the "chart_cyclic", I want to be able to see the break down of "sub category", (like the one shown in the bottom left corner). How can I do that?

Any help would be greatly appreciated!

[Nicole-Smith]

Have a look at the attached and see if it gives you what you need.

[#5]

Yes, this is exactly what I wanted to show.

One more question: if I switch to another cyclic group, such as "city", how do I make the drill down works (like what you did for the "category" group)? I was trying to modify the function within "Enable Conditional" in the Dimensions tab; but I couldn't make it to work. Any suggestions?

Thanks a lot!

[Nicole-Smith · Accepted solution]

If you look at the conditionals for the SubCategory and City dimensions, you'll see that I have:

GetCurrentField(G_cyclic)='Category' along with the GetSelectedCount()

So for whatever dimensions you want to use for the City part of the cyclic group, you just need to change the GetCurrentField to GetCurrentField(G_cyclic)='City'

[#7]

got it. thanks a lot!