Drill-Down Group Issue

[reshmakala]

Hello all,

I have been trying to do a drill down group in QlikView. I do not have values for all the fields. When I drill down to level2 I directly end up with the last level. Can anyone help me out.

Attached is the QVW that I am trying with.

Thanks in advance. !

[deepakqlikview_123]

Drill down group it used fotr hierarchical environment.I seems you are using nonhierachical group.

Technically when you uses drill down group in such cases it will directly drill down to its lowest level and shows only 1 possible value.

So use cyclic grp in your case.

Thanks

[maxgro]

- you have values for all fields; some values are blank

- when you only have 1 value, Qlik drill to lower level

So, you always have 1 possible value for every level, so Qlik will go from C1 to C5, always

if you change blank with null for some C1 value the drill down will stop at C3 or C4 level

load

C1,C2,C3,if(len(trim(C4))=0,null(),C4) as C4, if(len(trim(C5))=0,null(),C5) as C5;

LOAD * INLINE [C1, C2, C3, C4, C5,

a, b, c,

d,e,f,g,

h,i,j,k,l,

m,n,o,p,

q,r,s];

as Deepak Tibhe said, you have a nonhierachical group

[reshmakala]

Hello,

I tried it and now it stops at C3 after C1. I would actually need a drill down group functionality in my report. Is there any way I can do that with null values?

It should go from C1->C2->C3.... and so on. If there are no values it should stop drilling down there. Can that be possible?

[reshmakala]

If I use Cyclic Group I need to click the cyclic group icon and all the fields are expanded. I want the drill down functionality. Please let me know if there is any way.

[maxgro]

AFAIK if you only have 1 value in C2 (for the selected C1) Qlik will drill to C3 (if C4 is null or C4 if C5 is null; the last not null)

[reshmakala]

Okay Thanks! Sorry, I have another question. If I use Cyclic group, can I skip the fields with null values?

[#8]

Looking at the sample application, I am a not sure what "Salary" represents, since it is not associated with any particular categories.  As such, it is joined to all of them and, to me, it looks like it will be overstated.

The data is not explicitly hierarchical, but, if C1 is the highest level rollup category, C2, next highest and so on, until you reach a person and a salary.

Perhaps, assigning a Salary value to the lowest level of the "hierachy", in this case, "C", "G", "L", "P" and "S" and then making a pivot table instead of a straight table with a group?