topic Re: 32.What is the difference between a Cyclic group and a Drilldown group? in QlikView

32.What is the difference between a Cyclic group and a Drilldown group?

Thu, 08 May 2014 12:17:02 GMT

What is the difference between a Cyclic group and a Drilldown group?

Re: 32.What is the difference between a Cyclic group and a Drilldown group?

Thu, 08 May 2014 12:23:29 GMT

From the manual ....

DRILL DOWN

When several fields form a natural hierarchy, it makes sense to create a drill-down

group. Typical examples of hierarchic groups could be:

Time:Year, Quarter, Month

Geography: Continent, Country, State, City

When a drill-down group is used as a dimension in a chart, the chart will use the first

field in the group's list of fields that has more than one possible value. If selections

are made that cause the field to have only one possible value, the next field in the list

will be used instead, provided that it has more than one possible value. If no field in

the list has more than one possible value, the last field will be used anyway.

Cyclic

Sometimes it may be useful to group also fields which do not form a natural hierarchy

or even have nothing in common at all. The reason would be to enable the user to

make quick changes of the data to be displayed in a chart.

Any fields can be grouped together in a cyclic group. When a cyclic group is

used as a dimension in a chart, the chart will initially use the first field in the

group's list of fields. The user may then switch to another field by clicking the

cycle icon in the chart. The fields are used in the order they appear in the group's field

list. When the last field in the list has been used, the turn goes back to the first field.

The chart may be cycled indefinitely.

Re: 32.What is the difference between a Cyclic group and a Drilldown group?

sudeepkm — Thu, 08 May 2014 12:23:53 GMT

Given below is what from QlikView help. You can use QlikView help for your queries which has examples too.

Re: 32.What is the difference between a Cyclic group and a Drilldown group?

Thu, 08 May 2014 12:25:22 GMT

There is no relationship among the dimensions in Cyclic group, where as in Drilldown, like a parent and child relationship should be there.

Regards,

Ananth

Re: 32.What is the difference between a Cyclic group and a Drilldown group?

Thu, 08 May 2014 12:28:56 GMT

go through this video you can understand

Creating Cycle and Drill Groups

Re: 32.What is the difference between a Cyclic group and a Drilldown group?

Thu, 08 May 2014 12:34:20 GMT

Thankyou

Re: 32.What is the difference between a Cyclic group and a Drilldown group?

IAMDV — Thu, 08 May 2014 13:16:24 GMT

All these questions are Interview Questions. I've listed loads of interview questions on my blog without answers and Chandramohan just copied them from my blog. I wish he could have changed the text format but well he didn't!!

Copied from this URL:

http://qlikshare.com/qlikview-interview-qa/

Cheers,

Re: 32.What is the difference between a Cyclic group and a Drilldown group?

Thu, 08 May 2014 13:25:07 GMT

Deepak ... the effort you put towards qlikview community is invaluable ... i am a great fan of your blog, i do always follow. i am sure your reason for not giving answers definitely not to spoonfeed. and new learners can spend time reading and gain knowledge. i hope ppl understand that and spend sometime researching before posting questions.

Re: Re: 32.What is the difference between a Cyclic group and a Drilldown group?

IAMDV — Thu, 08 May 2014 13:36:56 GMT

Thanks you for encouraging words.

I wanted to make sure everyone learns/understand the underlying concept. That's the reason why I haven't posted answers to those interview questions. I can understand if someone wanted to know one or two answer(s), it's fair enough! but well, you are posting all the questions on community and taking shortcuts to get a job then it's not right at all.

Cheers,

Re: 32.What is the difference between a Cyclic group and a Drilldown group?

Thu, 08 May 2014 13:50:56 GMT

Deepak:

Thanks for your efforts.

ChandraMohan :

Please try to learn QlikView. Going thru interview questions and getting the answers will not help anyone.

Re: 32.What is the difference between a Cyclic group and a Drilldown group?

richard_pearce6 — Thu, 08 May 2014 13:56:39 GMT

And to add insult to injury none get marked as correct.

Spamming the community takes away the value. I work along side DV and he puts a lot of time and effort into helping others.

Some, it seems, decide they're above putting any effort into learning or the community for reasons unknown.

Shame on them !

Re: 32.What is the difference between a Cyclic group and a Drilldown group?

ngulliver — Tue, 13 May 2014 09:35:18 GMT

Hi, chandra18v.

Before posting questions like this, have a quick search in case someone has already posted the same question and received a reply (use search box in top right corner). It will be much quicker for you.

Also,if you don't get what you need on this forum, just to let you know there is a really good site available now called http://www.askqv.com/

It is a new site designed to go through only trusted QlikView related blogs to find matches to any of your Qlikview questions.

Cheers,

Neil

Re: 32.What is the difference between a Cyclic group and a Drilldown group?

chandnishah — Mon, 20 Jan 2020 04:51:37 GMT

@IAMDV is this link is still valid ?

http://qlikshare.com/qlikview-interview-qa/

Re: 32.What is the difference between a Cyclic group and a Drilldown group?

IAMDV — Tue, 14 Apr 2020 22:25:04 GMT

Sorry, no... my blog isn't working.