Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Drill Functionality not working as expected

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


6 Replies
Henric_Cronström

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

Not applicable
Author

Can you attach the sample of the same?

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

Selva

brijesh1991
Partner
Partner

I think you should try cyclic drill instead. ..

Not applicable
Author


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

Henric_Cronström

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

itmember
Creator
Creator

Hi Praveen.

have you found a solution for this

Please let me know