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: 
Anonymous
Not applicable

Year breakdown while using multiple dimensions

Hello,

I am running into an issue with not being able to provide a year to month breakdown while using a 2nd dimension to identify the individual values for UserBU.

Dimension 1 = Year >> Month

Dimension 2 = UserBU

When selecting the Year within the graph, my 2nd dimension is applied as a filter for the dashboard when I would like to have the Year be selected as the filter and also breakdown into months. All while displaying/using the 2nd dimension to identify the individual values for UserBU.

4 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

As I understand, what you need is to create a Drill-Down dimension Ozzie, so once you select a Year, it will go to the Month dimension and the graphs will act accordingly.

See this from help: https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Dimensions/create-drill-down-dime...

Felipe.

Anonymous
Not applicable
Author

I have a drill down currently setup, Year >> Month. The issue I run into is when I select the year within the graph this dimension is used, my 2nd Dimension of UserBU is applied as a filter and then the graph breaks out into months.

What I am trying to do is when the Year is selected within the graph, only the Year value is applied as a filter and not UserBU while still breaking down into months.

felipedl
Partner - Specialist III
Partner - Specialist III

Sorry, i'm having a difficult time to grasp the concept .

I've created some dummy data for testing (I just have view installed, but the same concept applies to Sense).

sales:

Load

UserBU,

Value,

Date#(Date,'MM-YYYY') as Year_Month;

Load * Inline

[

UserBU,Value,Date

1,100,01-2018

2,300,01-2018

3,1044,01-2018

4,103,01-2018

7,1033,02-2018

1,330,02-2018

3,105,01-2018

6,300,04-2018

1,100,06-2018

8,1100,05-2018

5,130,03-2018

3,550,02-2018

1,100,04-2018

2,300,05-2018

2,300,12-2017

];

let vMinDate = Num(MakeDate(2017,12));

let vMaxDate = Num(MakeDate(2018,6));

calendar:

Load

Num_Date,

Date(MonthStart(Num_Date),'MM-YYYY') as Year_Month,

Year(Num_Date) as Year;

Load

$(vMinDate) + IterNo() as Num_Date

AutoGenerate(1) while $(vMinDate) + IterNo() <= $(vMaxDate);

So this will only generate a calendar and some dummy data.

Next, i create the Year -> Year_Month drill-down dimension  and apply it and the UserBU to the graph, giving me the following:

Without selections:

sample.png

Selecting the Year:

sample2.png

Is this what you have?

Attached the QVW if you can use it.

Anonymous
Not applicable
Author

Thanks for your help Felip. I found the answer within the Master Calendar. Now i able to select the Year within a graph and it is applied as the Filter at the same time breaking down into months.