Pivot Chart Dimension

[Anonymous]

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

[Anonymous]

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;

[jagan]

Hi,

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

Regards,

Jagan.

[Anonymous]

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

[#5]

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‌

[Anonymous]

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 ?

[Digvijay_Singh]

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.

[#8]

Hi,

No idea, i hope its not possible.

Sub2u444‌

[jagan]

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.