Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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?
@Vegar How can we avoid the skipping if the dimension has only one value?
Any workaround?
Sorry, I'm not aware of any workaround. Please update this thread if you find a working solution to avoid skipping the dimension.
Vegar
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
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: