Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

13 Replies
Not applicable
Author

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

or

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.

sudeepkm
Specialist III
Specialist III

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

T117721.png

Not applicable
Author

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

Not applicable
Author

go through this video you can understand

Creating Cycle and Drill Groups

Not applicable
Author

Thankyou

IAMDV
Luminary Alumni
Luminary Alumni

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,

DV

Not applicable
Author

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.

IAMDV
Luminary Alumni
Luminary Alumni

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,

DV

Not applicable
Author

Deepak:

Thanks for your efforts.

ChandraMohan :

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