topic Re: drill down issue in QlikView

drill down issue

NavinReddy — Mon, 25 Aug 2014 14:32:53 GMT

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

Re: drill down issue

JonnyPoole — Mon, 25 Aug 2014 14:34:42 GMT

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.

Re: drill down issue

giakoum — Mon, 25 Aug 2014 14:34:59 GMT

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

Re: drill down issue

NavinReddy — Mon, 25 Aug 2014 14:39:36 GMT

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

Re: drill down issue

JonnyPoole — Mon, 25 Aug 2014 14:43:31 GMT

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.

Re: drill down issue

NavinReddy — Mon, 25 Aug 2014 14:45:14 GMT

Hi,

Please find the sample application

Regards

Niranjan

Re: Re: drill down issue

giakoum — Mon, 25 Aug 2014 14:48:30 GMT

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

Re: drill down issue

JonnyPoole — Mon, 25 Aug 2014 14:53:40 GMT

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

Re: drill down issue

christian77 — Mon, 25 Aug 2014 15:04:10 GMT

Hi.

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

Use a cyclic one instead.

Good luck.

Re: drill down issue

NavinReddy — Mon, 25 Aug 2014 15:27:22 GMT

Hi,

Again Im getting same results only

any other ideas

Regards,

Niranjan

Re: drill down issue

NavinReddy — Mon, 25 Aug 2014 15:28:21 GMT

Hi Jon,

This scenario what can i do

any other way to solve this Issue

Regards,

Niranjan

Re: drill down issue

JonnyPoole — Mon, 25 Aug 2014 15:33:29 GMT

Read this post. You can use a cycle or add null values to each level so there are technically always 2 values.

Drill Down Group Behavior not correct

Re: drill down issue

NavinReddy — Mon, 25 Aug 2014 15:40:33 GMT

Hi Jon ,

Thanks you So much

Really its helpful your suggestions,i got it now

Best Regards,

Niranjan