Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

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  Q1Smiley Sad200001:200003) Q2Smiley Sad200004:200005) as labels .

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

Regards

Latha

1 Solution

Accepted Solutions
elena888
Valued Contributor

Re: Calculated Dimension

Hi,

try to see if this qvw attached can help you!

KR,

Elena

3 Replies
MVP
MVP

Re: Calculated Dimension

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

Re: Calculated Dimension

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
Valued Contributor

Re: Calculated Dimension

Hi,

try to see if this qvw attached can help you!

KR,

Elena

Community Browser