Drill Down Group issue

[Anonymous]

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

[morganaaron]

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.

[sujeetsingh]

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

Try using cyclic group

[Anonymous]

But how can you change default behaviour of drill down?

[morganaaron]

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?

[sushil353]

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

[sushil353]

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

[Anonymous]

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

How to add null value only for that particular colmn?

[Anonymous]

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

[balar025]

Hi,

This document might help or you might already have solution.

Drill Down issue overcome

Regards,

Ravi Balar