topic Drill down not working as expected in QlikView

Drill down not working as expected

divya_anand — Tue, 16 Aug 2016 09:46:42 GMT

Hi all,

I have an issue working with Drill down group. There are 4 stages in my application R1->P1->C1->E1.

When I make selection within the bar chart and when I want to drill up E1->C1->P1->R1->, everything is working fine.

However, if I have to make selections using a list box for R1, P1, C1 & E1, I am not able to drill up from C1->P1.

Why is this?

Re: Drill down not working as expected

swuehl — Tue, 16 Aug 2016 10:05:30 GMT

I can't reproduce this easily.

Could you post a small sample QVW that demonstrates your issue?

There might be an issue if your selections are limiting your record set to one possible value for P1, so you will get drilled down to C1 level automatically, but I don't think this behaviour is depending on where you are making your selections.

Re: Drill down not working as expected

Colin-Albert — Tue, 16 Aug 2016 10:06:50 GMT

Drill down can skip a level if there is only a single value returned.

For example if your selections on R1, P1, C1 and E1 return a single result for P1, your chart will drill from R1 > C1 > E1 skipping the P1 level as it is a single result

Re: Drill down not working as expected

divya_anand — Wed, 17 Aug 2016 07:20:00 GMT

Hi,

Thank you all for your responses. There was a mistake in the dimensions I chose, my bad.