topic Re: Drill-Down Group Issue in QlikView

Drill-Down Group Issue

reshmakala — Sun, 14 Sep 2014 15:54:20 GMT

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. !

Re: Drill-Down Group Issue

deepakqlikview_123 — Sun, 14 Sep 2014 16:21:55 GMT

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

Re: Drill-Down Group Issue

maxgro — Sun, 14 Sep 2014 16:35:14 GMT

- 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

Re: Drill-Down Group Issue

reshmakala — Sun, 14 Sep 2014 17:47:41 GMT

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?

Re: Drill-Down Group Issue

reshmakala — Sun, 14 Sep 2014 17:49:08 GMT

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.

Re: Drill-Down Group Issue

maxgro — Sun, 14 Sep 2014 19:19:08 GMT

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)

Re: Drill-Down Group Issue

reshmakala — Mon, 15 Sep 2014 13:40:43 GMT

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

Re: Drill-Down Group Issue

Mon, 15 Sep 2014 19:26:51 GMT

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?