Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Announcements
Qlik's 15-week Applied Data Analytics using Qlik Sense course. Classes start Jan. 17, 2022. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated Dimension

Hi,

  I have two dimensions in my chart : Quarter  (Q1,Q2,Q3,Q4) and Year Month (200001,200002,200003......200012)

  I am using line graph In which , I want to display at x-axes both Quarter and YearMonth like  Q1:(200001:200003) Q2:(200004:200005) as labels .

  can anyone help me out to write calculated dimension query trick!!

Regards

Latha

1 Solution

Accepted Solutions
elena888
Specialist
Specialist

Hi,

try to see if this qvw attached can help you!

KR,

Elena

View solution in original post

3 Replies
MK_QSL
MVP
MVP

Create a Bar Chart

First Dimension Quarter

2nd Dimension YearMonth

Expression

1) SUM(YourFieldName)

2) 0

Now Go to Presentation Tab and Untick Show Legend

Hope this is what you are looking for..

Not applicable
Author

Sorry I will make it clear:

                   I have a dataset with YearMonth (200001,200002,200003......201512) and sum(sales) in one table.

In other table  I have

Quarter:

LOAD * INLINE

[Month, Quarter, Fin_Quarter

1, Q1, Q3

2, Q1, Q3

3, Q1, Q3

4, Q2, Q4

5, Q2, Q4

6, Q2, Q4

7, Q3, Q1

8, Q3, Q1

9, Q3, Q1

10, Q4, Q2

11, Q4, Q2

12, Q4, Q2

];

 

Now In line graph i want the dimension as 2000Q1,2000Q2,2000Q3,2008Q4,2009Q1.......2015Q4 and sum(sales) as measure/metric

elena888
Specialist
Specialist

Hi,

try to see if this qvw attached can help you!

KR,

Elena

View solution in original post

Community Browser