topic Re: Is it possible to make a cyclic with drill down function? in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619104#M1115030 <HTML><HEAD></HEAD><BODY><P>got it. thanks a lot!</P></BODY></HTML> Fri, 21 Feb 2014 21:18:35 GMT 2014-02-21T21:18:35Z Is it possible to make a cyclic with drill down function? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619098#M1115024 <HTML><HEAD></HEAD><BODY><P>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!</P></BODY></HTML> Fri, 21 Feb 2014 16:49:25 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619098#M1115024 2014-02-21T16:49:25Z Re: Is it possible to make a cyclic with drill down function? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619099#M1115025 <HTML><HEAD></HEAD><BODY><P>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:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4311">QlikView App: Dynamic Date Dimension</A></P><P></P><P>You could have a number of different Dynamic Dimensions in a single Cycle group.</P><P></P><P>Hope that helps,</P><P><A href="https://community.qlik.com/qlik-users/4484">Steve Dark</A></P></BODY></HTML> Fri, 21 Feb 2014 16:53:03 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619099#M1115025 stevedark 2014-02-21T16:53:03Z Re: Re: Is it possible to make a cyclic with drill down function? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619100#M1115026 <HTML><HEAD></HEAD><BODY><P>Thank you for your quick response.</P><P></P><P>But I still want to allow the user to switch between views using cyclic group.</P><P></P><P>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?</P><P></P><P>Any help would be greatly appreciated!</P></BODY></HTML> Fri, 21 Feb 2014 18:55:10 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619100#M1115026 2014-02-21T18:55:10Z Re: Re: Re: Is it possible to make a cyclic with drill down function? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619101#M1115027 <HTML><HEAD></HEAD><BODY><P>Have a look at the attached and see if it gives you what you need.</P></BODY></HTML> Fri, 21 Feb 2014 19:14:06 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619101#M1115027 Nicole-Smith 2014-02-21T19:14:06Z Re: Re: Re: Is it possible to make a cyclic with drill down function? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619102#M1115028 <HTML><HEAD></HEAD><BODY><P>Yes, this is exactly what I wanted to show. </P><P>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?</P><P></P><P>Thanks a lot!</P></BODY></HTML> Fri, 21 Feb 2014 20:29:20 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619102#M1115028 2014-02-21T20:29:20Z Re: Is it possible to make a cyclic with drill down function? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619103#M1115029 <HTML><HEAD></HEAD><BODY><P>If you look at the conditionals for the SubCategory and City dimensions, you'll see that I have:</P><P><STRONG>GetCurrentField(G_cyclic)='Category'</STRONG> along with the GetSelectedCount()</P><P></P><P>So for whatever dimensions you want to use for the City part of the cyclic group, you just need to change the GetCurrentField to <STRONG>GetCurrentField(G_cyclic)='City'</STRONG></P></BODY></HTML> Fri, 21 Feb 2014 20:33:42 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619103#M1115029 Nicole-Smith 2014-02-21T20:33:42Z Re: Is it possible to make a cyclic with drill down function? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619104#M1115030 <HTML><HEAD></HEAD><BODY><P>got it. thanks a lot!</P></BODY></HTML> Fri, 21 Feb 2014 21:18:35 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-a-cyclic-with-drill-down-function/m-p/619104#M1115030 2014-02-21T21:18:35Z