Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sheetal
Contributor II
Contributor II

Drill down master dimension - skipping a level

Hello experts

I really need help in solving this issue. I have the following master dimension, all fields are from the same table;

PD_MonthYear

PD_Department

PD_WorkshopID

I have the following table 

Month Year                    |                        AttendeeCount               |       Creditscount

June2018                                                 200                                                199

Oct2018                                                   200                                                  199

I am trying to drill down the month year to department and then the workshop id.

This seems to work fine when I load the app for the first time and make the first selection. However when I clear selections and second another MonthYear, the department dimension is completely skipped.

Any solution to this ? 

 

Labels (1)
6 Replies
Vegar
MVP
MVP

From my experience a level is skipped only when you have just one available value available in that dimension. So if you make selections in a YearMonth where you only have one Department you could skip down a layer to the Workshop ID.
Sheetal
Contributor II
Contributor II
Author

Thanks for your reply.  You are right, I checked the data and it doesn't seem to happen when the YearMonth selection has more than 1 department. Do you know what is the solution for this?

kalyanamharish
Contributor III
Contributor III

@Vegar  How can we avoid the skipping if the dimension has only one value?
Any workaround?

Vegar
MVP
MVP

Sorry,  I'm not aware of any workaround.  Please update this thread if you find a working solution to avoid skipping the  dimension.

Vegar

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

A workaround I have used successfully is to load an additional value -- a null -- for field(s) that have only one value.  The value will not appear in the chart but will be treated as a value by the drill logic. That will force a selection to cause drill down.  See the attached qvf for an example. Script something like this:

data:
LOAD * INLINE [

Cat,ProductId,Amt
GroupA,a,10
GroupA,b,10
GroupA,c,10
GroupA,d,10
] ;
CONCATENATE
LOAD null() as Cat
AUTOGENERATE 1;

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

lorenzoconforti
Specialist II
Specialist II

Instead of a master dimension you could use a calculated dimension that picks the correct dimension level based on current selection

Have a look here:

https://community.qlik.com/t5/Qlik-Sense-App-Development/Configure-a-drill-down-dimension-by-typing-...