topic Re: hierarchy drill-down in QlikView

hierarchy drill-down

Mon, 26 Sep 2011 13:40:21 GMT

Hi all,

i've defined a hierarchy group in a pivot table. (see qvw in attachment)

i start with drill in chart. first drill-down:

result:

after second drill down

the drill jump to D4 and not to D3. This is right for how to is defined drill in qlik, but is not right for my logic. How can i solve thi problem?

Re: hierarchy drill-down

hdonald — Tue, 27 Sep 2011 11:04:09 GMT

Hi,

The usual work-around is to add a null value in each category that will show a single row - see Rob Wunderlich's example qvw in this recent post for adding a null value for each dimension where there will be only one value on the drill.

http://community.qlik.com/message/133826#133826

It does mean you'll have to add something to the script to identify those rows and concatenate the extra nulls in - maybe like in the attached example - which gets more involved the more levels you have,

Regards,

Re: hierarchy drill-down

Tue, 27 Sep 2011 14:39:05 GMT

Thx so much!

Obiuvsly your tip works only if the rows are loaded in order like this:

LOAD * INLINE [

D1, D2, D3, D4

A, fcs1, kpi1.1, 112

A, fcs1, kpi1.1, 113

A, fcs2, kpi2.1, 211

A, fcs2, kpi2.1, 212

A, fcs2, kpi2.2, 221

A, fcs3, kpi3.1, 311

A, fcs3, kpi3.2, 321

B, fcs4, kpi4.1, 411

B, fcs4, kpi4.1, 412

B, fcs4, kpi4.2, 421

B, fcs5, kpi5.1, 511

B, fcs5, kpi5.1, 512

B, fcs5, kpi5.1, 513

B, fcs5, kpi5.2, 521

B, fcs5, kpi5.2, 522

B, fcs6, kpi5.2, 523

];

otherwise function "previous" don't do the right thing.

Moreover i make an adjustment because in a case the tip doesn't works. The case is when there is one D1, one D2, one D3 but more than one D4. See attachment. In any case thank you so much for support!