topic Re: Drill Functionality not working as expected in QlikView

Drill Functionality not working as expected

Thu, 09 Jan 2014 11:03:16 GMT

Hi Champs,

I am using to 2 fields Top Parent and Parent. I have created a Drill down group so that we can drill from Top Parent-->Parent.

This is working for some of them where as in some cases its directly showing up Parent details instead of rolling up and showing Top Parent Details. Am using this Group as a dimension for a Bar Chart and Expression is Revenue.

Any idea on why is this behaving so?

Thanks & Regards,

Praveen

Re: Drill Functionality not working as expected

hic — Thu, 09 Jan 2014 11:18:07 GMT

The logic is that it drills down automatically to the next level if there is only one possible value.

If you don't want this, then you can use a cyclic group instead, or adding a NULL value in the data. See more on http://community.qlik.com/thread/73465

HIC

Re: Drill Functionality not working as expected

Thu, 09 Jan 2014 11:19:31 GMT

Can you attach the sample of the same?

If both the columns are linked in your datamodel it will work as expected...

Selva

Re: Drill Functionality not working as expected

brijesh1991 — Thu, 09 Jan 2014 11:39:38 GMT

I think you should try cyclic drill instead. ..

Re: Re: Drill Functionality not working as expected

Thu, 09 Jan 2014 14:50:47 GMT

Hi Henric,

After going through the link you have provided, I was trying to implement....

Please refer the attached file...Once I select the entity_name am seeing the prd_desc the second level of values where as it not rolling up to the first level even after using the NULL value.

Please help me on this.

Thnaks & Regards,

Praveen Palle

Re: Re: Drill Functionality not working as expected

hic — Thu, 09 Jan 2014 15:05:08 GMT

As soon as you make a selection, the NULLs will be excluded and the chart will drill down. The NULLs only help you in the case that there is no selection.

If you don't want it to drill down, you should use a cyclic group.

HIC

Re: Re: Drill Functionality not working as expected

Anonymous — Thu, 14 May 2015 19:30:40 GMT

Hi Praveen.

have you found a solution for this

Please let me know