Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Drill down issue for one possible value

passionate
Valued Contributor

Drill down issue for one possible value

Drill down Issue

I have a drill down object which includes:

1. Continent

2. Country

3. State

4. Branch

I am drilling from Continent ='Asia' -> Country='Ind' then

There are two possible States for Country= ‘Ind’ so, in chart is showing state value.

Refer Scenario 1 screenshot.

Issue:

Whenever there is single possible value in drill down the level is skipped see example below:

I am drilling from Continent ='Europe' -> Country='Finland' then there is only one possible state as Helsinki.

So, This drill down level is skipped.

Refer Scenario 2 screenshot.


Ideally Bar chart should show Helsinki.

But, because there is only one possible value in state so, this level is skipped.

Resolution:

Add Null value to all dimensions so that there are two possible values in this case 0 and Helsinki.

Refer Scenario 3 screenshot.


Now the chart halts at Helsinki.

I have attached sample Qlikview Application for reference.

Cheers,

Pankaj

Comments
hector_munoz_in
Valued Contributor

Good issue, Pankaj!

manojkulkarni
Valued Contributor II

Good. Thanks for sharing. We faced this issue many times

balar025
Contributor III

Pankaj, Nice Way to overcome drill issue.

I have another way to resolve this issue without adding NULL. Here is the document.

Drill Down issue overcome

Version history
Revision #:
1 of 1
Last update:
‎06-30-2017 05:57 AM
Updated by: