topic Re: Re: Pivot chart in QlikView

Pivot chart

Tue, 18 Nov 2014 06:00:36 GMT

i have pivot chart , have three dimensions :

year

Quarter

month

i change setting to fully expanded " but these three dimension are showing in three separate columns.

And i want to club them into one column only (not three separate columns)

2013

Jan

Feb

March

April

May

June

like this

is it feasible???

Re: Pivot chart

Tue, 18 Nov 2014 06:04:58 GMT

could you please share your sample application to understand your requirement..

Re: Re: Pivot chart

Tue, 18 Nov 2014 06:14:24 GMT

requirement is like this

Re: Pivot chart

jagan — Tue, 18 Nov 2014 06:16:27 GMT

Hi,

I think it is not possible exactly, check Indent Mode option in Style tab or select Data(Vertical) as Top in Presentation tab for all the dimensions.

Hope this helps you.

Regards,

jagan.

Re: Re: Re: Pivot chart

ashfaq_haseeb — Tue, 18 Nov 2014 06:19:43 GMT

HI,

That not directly possible.

1 work around could be.

Regards

ASHFAQ

Re: Pivot chart

Tue, 18 Nov 2014 06:24:11 GMT

Hi gurjeet,

All three field in one column is not possible but adding some colors and hiding cell border you can change the look and feel of the table,and change the partial sum option from month to quarter which make more clear calculation.Hope this helps you

Re: Pivot chart

jonathandienst — Tue, 18 Nov 2014 06:28:49 GMT

This is not exactly what you are requesting but very close:

In the pivot table Chart Properties | Style dialog, check Indent Mode and optionally check Use Only First Dimension Label. Now drag the column boundaries to something like this:

HTH

Jonathan

Re: Pivot chart

Tue, 18 Nov 2014 06:38:33 GMT

hope this help you