Drill down dimension in qliksense

[Aspiring_Developer]

Hello All,

I have created a drill down dimension in qliksense like below :-

But when I am passing this dimension in chart, it is not working . Please see below :-

In Bar chart , i am unable to toggle to other dimension. Similarly when I take this drill down dimension in table , it is coming as a single field only . Am i doing something wrong ? Please suggest.

Thanks is advance

[stevejoyce]

Drill downs only display a single field at a time.  If you select 1 value in the drill down tree, it will display the next field level.  You don't use drill down to cycle fields.  

If you select "Group" in your Division Name field, it should then show all Department Names under that Division.  That's the use of it.

[Aspiring_Developer]

Hi @stevejoyce 

So , that means for my requirement i need to use cyclic group instead of drill down ?

[stevejoyce]

Yes that sounds like what you are looking for.

There are some postings on how to workaround no native cyclic dimension, you can look at this for example:

https://community.qlik.com/t5/Qlik-Sense-Documents/Cyclic-Groups-in-Qlik-Sense/ta-p/1763172