topic Re: Chart dimension interchange in QlikView

Chart dimension interchange

Anonymous — Mon, 12 Jan 2015 15:51:23 GMT

Good morning everyone!

I have simple pivot table, let say as below.

Where Scenario is Dimension and 1Q14, ..4Q14 are Expressions

Scenario 1Q15 2Q15 3Q15 4Q15

BB 3.0 3.5 2.4 3.7

BA 5.2 2.6 3.9 2.8

FB 1.9 4.5 3.5 3.1

FA 5.2 2.6 3.9 2.8

FSA 1.9 4.5 3.5 3.1

With above example I have been getting Line chart as

Scenario on X axis and all Expressions values being displayed on Y axis as attachment.

But I want other way like 1Q15...4Q15 on X-axis. I tried changing dimension on Pivot side but unable to do so.

Is there any way without redefine dimension on Pivot?

Thanks for your time

Re: Chart dimension interchange

Clever_Anjos — Mon, 12 Jan 2015 15:59:32 GMT

Are you using same object with fast change?

Re: Chart dimension interchange

Anonymous — Mon, 12 Jan 2015 16:13:09 GMT

Yes

Re: Chart dimension interchange

Clever_Anjos — Mon, 12 Jan 2015 16:22:48 GMT

PFA

Re: Chart dimension interchange

Anonymous — Mon, 12 Jan 2015 16:29:06 GMT

Hi Clever

Nice solution , still I am trying to figure out, did you merged?

Thanks a lot for effort

Re: Chart dimension interchange

Clever_Anjos — Mon, 12 Jan 2015 16:40:30 GMT

1) Create your pivot table

2) Mark Fast Change for Pivot and Line

3) Click "Line" type at presentation level and change the order of dimensions

Re: Chart dimension interchange

Anonymous — Mon, 12 Jan 2015 16:55:57 GMT

Thanks for update

Re: Chart dimension interchange

Anonymous — Mon, 12 Jan 2015 17:37:58 GMT

Hi Clever

I am unable to see below option at Presentation Tab, nor order option

3) Click "Line" type at presentation level and change the order of dimensions

Btw, I have one dimension but multiple expressions

Could you elaborate please. Thanks

Re: Chart dimension interchange

Clever_Anjos — Mon, 12 Jan 2015 17:47:31 GMT

Well, I´m going to play with your data, and try to find a solution

Re: Chart dimension interchange

Clever_Anjos — Mon, 12 Jan 2015 17:49:51 GMT

Would you mind to show me 1Q15 expression?

Re: Chart dimension interchange

Anonymous — Mon, 12 Jan 2015 17:55:47 GMT

Sum({$<QUARTER = {2}, LINE_NUMBER = {'7','21'}>} PROJECTION_VALUE)

1Q15 is basically QUARTER 2 in database

LINE_NUMBER is just for filter

Re: Chart dimension interchange

Clever_Anjos — Mon, 12 Jan 2015 18:17:15 GMT

Why don´t use Sum({$<LINE_NUMBER = {'7','21'}>} PROJECTION_VALUE) as expression and QUARTER as dimension?

Re: Chart dimension interchange

Anonymous — Mon, 12 Jan 2015 18:33:47 GMT

I achived by this. Thanks

Now any idea how come I see only one Legend name at chart top?
Any idea to remove/hide?

Re: Chart dimension interchange

Clever_Anjos — Mon, 12 Jan 2015 18:44:07 GMT

This is set using at "Presentation Tab" , there is a textbox right below a check box called "show title in the chart"

Re: Chart dimension interchange

Anonymous — Mon, 12 Jan 2015 19:07:55 GMT

Got it, thanks for valuable time