Drilldown issue with group in bar chart

[guyvermeiren]

Hello,

I have a bar chart with grouped dimensions.

These are the dimensions:

Dimensions

The group I made is:

So if click in my bar chart on Target the chart goes to level 2

The problem is when I click on Key the chart jumps immediately to level 3 because there is only 1 value in Level 2.

How can I avoid this ??

Thanks,

Guy

[adamdavi3s]

Hi Guy,

This is normal Qlik behaviour but there are some good workarounds on this thread

Drill Down Group Behavior not correct

Kind regards

Adam

[sasikanth]

HI,

Try to add a dummy record for Level1 in Qlikview like below

LOAD * Inline [

Leve1,Level2,Level3,sales

Key,Key1,A,10

Key,Key1,B,200

Tab,Tab1,C,30

Tab,Tab2,D,400

Temp,Temp1,E,50

Temp,Temp2,F,300

];

Load * Inline [

Leve1,Level2,Level3,sales

Key,null ,

];

Then check in front end. Please refer attached file

[guyvermeiren]

Hello Adam,

I tried to work with a formula in the group that i found in the workaround with example.

I goes like this:

In the example it worked.

In my application there's one one value for Key when I go from the 1st to the 2nd level.

It still doesn't work with this formula.

Is there something wrong in my formula ??

Thanks,

Guy

[adamdavi3s]

Hi Guy,

Here is a simple example which shows it working OK

Yours looks OK to me but without the app it is hard to see!

Adam