Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Niru
Contributor II

drill down issue

Dear Experts,

I have an issue

I created drill down ,when i added this in to chart its not working

I have 4 levels,directly its applying level2 in chart

i am not getting level1 in my chart ,its showing directly in level2

Please some one help me

Thanks In Advance

Niranjan

1 Solution

Accepted Solutions
Employee
Employee

Re: drill down issue

So if you drill on 'allocations out' in 'Account rollup 3' it will jump straight to Acct 3 because the 2 levels between just have 1 value

drill.png

12 Replies
Employee
Employee

Re: drill down issue

It could be that only 1 value is in the top level , or your current selections have filtered it down to 1 value.

Drill down groups will auto-drill down when there is only 1 value... just as if you clicked the 1 value to drill down.

giakoum
Honored Contributor II

Re: drill down issue

is there data for level 1? A sample application would help.

Niru
Contributor II

Re: drill down issue

Hi Jon,

I agree but in middle also its giving problem,

Acct1,Acct2,Acct3,Acct4

But in this im not getting Acc3,its going directly Acct4

Any Suggestions please

Regards,

Niranjan

Employee
Employee

Re: drill down issue

it would be the same behaviour whether its a single value in the top or middle, it will auto-drill to the level beneath until you encounter a level with more than 1 value, or you reach the bottom. 

is this consistent with what you are seeing ?

try creating a pivot table with the 4 levels and checking that your drill path you are testing has 1 or more values where it appears to jump an extra level (or more) down.

Niru
Contributor II

Re: drill down issue

Hi,

Please find the sample application

Regards

Niranjan

giakoum
Honored Contributor II

Re: Re: drill down issue

Your group was in the wrong order (see attached app);

Capture.PNG.png

Employee
Employee

Re: drill down issue

So if you drill on 'allocations out' in 'Account rollup 3' it will jump straight to Acct 3 because the 2 levels between just have 1 value

drill.png

christian77
Valued Contributor

Re: drill down issue

Hi.

I don't like drill groups. You all know why.

Use a cyclic one instead.

Good luck.

Niru
Contributor II

Re: drill down issue

Hi,

Again Im getting same results only

any other ideas

Regards,

Niranjan

Community Browser