Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the difference between a Cyclic group and a Drilldown group?
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.
Given below is what from QlikView help. You can use QlikView help for your queries which has examples too.
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
go through this video you can understand
Thankyou
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
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.
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
Deepak:
Thanks for your efforts.
ChandraMohan :
Please try to learn QlikView. Going thru interview questions and getting the answers will not help anyone.