Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Hi,
Please find attached file for solution. Enable Partial sum option in Presentation tab for Region and Area dimension.
Regards,
Jagan.
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
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 ...
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 ?
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.
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.