topic Re: Pivot Chart Dimension in QlikView

Pivot Chart Dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a question about dimension in pivot chart.

I have 2 pivot chart object, first chart using two dimension (Region and Area), the second chart using one dimension (Region).

My purpose is, i want to combine two object (first chart and second chart) into one object.

So the object will be like this,

Region Area Brand B1 B2

A Area1 1 -

A Area2 2 -

A Area3 - 3

B Area4 4 -

B Area5 - 5

B Area6 - 6

A A 3 3 ------> from the second chart

B B 4 11

Total 7 14 -------> total

is it possibe to make it ?

I also attach my sample data and qlikview file.

Really appreciate your help.

Thanks

Re: Pivot Chart Dimension

Anonymous — Fri, 11 Mar 2016 05:53:53 GMT

Hi ,

Try this

T1:

LOAD * INLINE [

Region, Area, Brand, Qty

A, Area1, B1, 1

A, Area2, B1, 2

A, Area3, B2, 3

B, Area4, B1, 4

B, Area5, B2, 5

B, Area6, B2, 6

];

Concatenate:

load Region&' ' as Region,Region as Area, Brand, Qty Resident T1;

Re: Pivot Chart Dimension

jagan — Fri, 11 Mar 2016 06:01:25 GMT

Hi,

Please find attached file for solution. Enable Partial sum option in Presentation tab for Region and Area dimension.

Regards,

Jagan.

Re: Pivot Chart Dimension

Anonymous — Fri, 11 Mar 2016 06:37:47 GMT

Hi Jagan,

Thanks for your reply.

But my problem is not only to show the total.

I want to combine two object with different dimension into one object.

Region Area Brand B1 B2

A Area1 1 - ------> first chart

A Area2 2 -

A Area3 - 3

B Area4 4 -

B Area5 - 5

B Area6 - 6

A A 3 3 ------> from the second chart

B B 4 11

Is it possible ?

Thanks in advance

Re: Pivot Chart Dimension

Fri, 11 Mar 2016 06:42:29 GMT

Hi Lejours,

PFB Snippet...

Dimensions :- Region,Area,Brand

Expression :- sum(Qty) , Label - Qty

Presentation>Region>enable"show partial sums".

If you required "Area" level, then enable "show partial sums"....

Drag the Brand column and drop the Qty label.

Now you will get the above one... i hope it will help you

Please check ...

Sub2u444‌

Re: Pivot Chart Dimension

Anonymous — Fri, 11 Mar 2016 06:49:07 GMT

Hi.

Thanks for reply.

I've already show the chart.

But i want to combine two chart into one. so the chart will be like this:

Region Area Brand B1 B2

A Area1 1 - ------> first chart

A Area2 2 -

A Area3 - 3

B Area4 4 -

B Area5 - 5

B Area6 - 6

A A 3 3 ------> from the second chart

B B 4 11

tha last row is from second chart that only has one dimension (Only Region).

do you have any idea ?

Re: Pivot Chart Dimension

Digvijay_Singh — Fri, 11 Mar 2016 07:02:22 GMT

I think it is not possible at least through front end as you are trying to so value of one dimension in other and multiple formula in one expression based on mixed values of Region and Area under Area dimension. I suggest instead of merging like this you can keep different charts placed close to each other. You may confuse users by mixing different granularity dimensions and expressions together.

Re: Pivot Chart Dimension

Fri, 11 Mar 2016 07:10:46 GMT

Hi,

No idea, i hope its not possible.

Sub2u444‌

Re: Pivot Chart Dimension

jagan — Fri, 11 Mar 2016 07:27:38 GMT

Hi,

Try like this in script

Data:

LOAD Region & Area AS Key,

Region,

Area,

Brand,

Qty

FROM

[sample data (2).xlsx]

(ooxml, embedded labels, table is Sheet1);

Region:

LOAD DISTINCT

Region & Area AS Key,

Region,

Area

RESIDENT Data;

Concatenate(Region)

LOAD

DISTINCT

Region & Area AS Key,

Region,

Region AS Area

RESIDENT Data;

DROP FIELDS Region, Area FROM Data;

Regards,

Jagna.