topic Re: drill-down groups in QlikView

drill-down groups

Tue, 04 Mar 2014 21:27:23 GMT

hi,

i have this pivot table (full Expanded)

i've made a drilldown group with this same fields and it works fine but when i select "Centro" it goes directly to "Sub-Segmento", i think it's because there's only one choice "Maria".

How can i show this choice and avoid to go directly to the 3rd drill-down Field.

tnks

Re: drill-down groups

Anonymous — Tue, 04 Mar 2014 21:39:18 GMT

check your drill down group order...it should be Regional, Jefe de Zona and Sub-Segmento.

assuming you have it that way, it is weird that it only works that way with centro. what happens with Sur? Sur has only one value/choice as well.

Re: drill-down groups

Tue, 04 Mar 2014 21:42:46 GMT

hi, you are correct i take Centro as an example to the question but it happens with the "Sur" too.

Re: drill-down groups

Carlos_Reyes — Tue, 04 Mar 2014 21:48:26 GMT

It is working as designed... Review these similar discussions:

RNAM - Topline is shown in my drilldown structure

I notice in drill down it is bypassing one level of hierarchy.

Re: drill-down groups

Anonymous — Tue, 04 Mar 2014 21:51:08 GMT

Hi Carlos,

it is the standard behaviour for drill down groups, if there is only one value for a level this will be skipped.

Re: drill-down groups

Tue, 04 Mar 2014 23:50:08 GMT

tnks

i use your conditional code:

For the top field:

getselectedcount( TopField )<1

For the next field

getselectedcount( TopField )=1 and getselectedcount( NextFieldName ) <1

For the third field

getselectedcount( TopField )=1 and getselectedcount ( NextFieldName ) = 1 andgetselectedcount( ThirdFieldName ) <1