topic Re: Drill Down Group issue in QlikView

Drill Down Group issue

Anonymous — Wed, 05 Nov 2014 10:54:17 GMT

I am using drill down group for showing Country-Region-State. in straight table.

What I observer that if any of group have only one possible value.It will skip that level and go to next level.

For e.g Country X have 2 region say A,B then it will show region level after clicking on X.

But in case If Country X have only a region say A it will skip region level and move to next level that is state.

Is there any way to show region even it has single possible value.

Thanks

Kiran

Re: Drill Down Group issue

morganaaron — Wed, 05 Nov 2014 10:58:47 GMT

You could replace the drill down group with conditional dimensions based on selections?

If you use GetSelectedCount(Country)=1 as a condition for Region, this would only then appear when 1 is selected, rather than 1 is possible. If you apply the inverse logic to the other fields calculation then you should be able to replicate all the layers.

Re: Drill Down Group issue

sujeetsingh — Wed, 05 Nov 2014 11:03:59 GMT

It is a strange behave, if possible please send the sample please.

Try using cyclic group

Re: Drill Down Group issue

Anonymous — Wed, 05 Nov 2014 11:05:38 GMT

But how can you change default behaviour of drill down?

Re: Drill Down Group issue

morganaaron — Wed, 05 Nov 2014 11:08:54 GMT

I don't think you can, that's the way it's set up to work - unless it's the final field that you've drilled down to, if there is only 1 possible selection in the field above, then it will naturally drill down into that one selection.

You could always add a null value to each category which should stop the automatic behaviour?

Re: Drill Down Group issue

sushil353 — Wed, 05 Nov 2014 11:11:18 GMT

Hi,

this is default behavior of QlikView to bypass the single value in drill down..

To alter this behavior you could add null value for each category while loading the data.. in this way QlikView will show the single value as well..

HTH
Sushil

Re: Drill Down Group issue

sushil353 — Wed, 05 Nov 2014 11:17:35 GMT

test using below query..

Load * inline

[

region,state,city,sales

North,Delhi,A,4

North,,,

South,Kerla,as,5

South,TN,BS,6

];

here I have added null value for state Delhi.. since it has only one value.

HTH

Sushil

Re: Drill Down Group issue

Anonymous — Wed, 12 Nov 2014 13:24:18 GMT

How to identify if particular dimension have value 1 in hirarchy in script ?

How to add null value only for that particular colmn?

Re: Drill Down Group issue

Anonymous — Mon, 04 May 2015 13:05:57 GMT

Hi Kirankkk,

Please let me know if you have found a solution for this.

I have have the same issue and I have multuple chart which have one or more drilldown and/or cyclic groups

Re: Drill Down Group issue

balar025 — Mon, 10 Jul 2017 06:51:48 GMT

Hi,

This document might help or you might already have solution.

Drill Down issue overcome

Regards,

Ravi Balar