Grouping of dimension in a Qlikview Pivot Table

[ramchalla]

Hi,

I have a requirement in Qlikview where i need to display a pivot table with dimensions and some measures. But the 3rd dimension is combination of three dimensions, say Region, County, Business Unit. So i need to display all these three dimension values in the 3rd dimension in pivot table.

Kindly help me if it is possible in qlikview. if possible, kindly let me know how to do that?

Thanks,

Ramesh.

[swuehl]

What do you mean with that combination of dimensions?

Note that you can create a new, concatenated dimension in the script or as calculated dimension in the chart

Dim1 & ' / ' & Dim2 & ' / ' & Dim3

[ramchalla]

All the 3 dimension values will display in a single dimension.

I could see the solution in some other post.

Qlikview Pivot Table Combine 2 Dimensions in Field

Thank you so much Stefan.

But now i am facing the problems with the coloring and Grouping. The first dimension in the grouping should have one color, the second dimension with some other color and 3rd dimension with some different color.

Could you please help me how to achieve this?

[swuehl]

Could you provide a small sample application?

[ramchalla]

Please find the below data. I am unable to attach the file.

X	Y	Z	A	B	C	D
CIL Total			4,511	5,622	(2,013)	0	3,610	(60)	3,550
G&O  Total			4,511	5,622	(2,013)	0	3,610	(60)	3,550
APAC		1,134	1,005	(597)	0	408	0	408
	India	1,111	939	(357)	0	583	0	583
	cognizant	23	65	(240)	0	(175)	0	(175)
MiddleEAST		671	1,519	(409)	0	1,111	(40)	1,071
	Dubai	297	919	(178)	0	741	0	741
	tcs	187	300	(115)	0	185	(20)	165
	infosys	187	300	(115)	0	185	(20)	165
North America		187	300	(115)	0	185	(20)	165
	USA	187	300	(115)	0	185	(20)	165
South America		2,519	2,798	(892)	0	1,906	0	1,906
	Brazil	297	919	(178)	0	741	0	741
	Paraguay	2,222	1,879	(714)	0	1,165	0	1,165
	microsoft	1,111	939	(357)	0	583	0	583
	hewlett packard	1,111	939	(357)	0	583	0	583
Brazil and Paraguay, India, Dubai and USA are from Region dimension
Cognizant,tcs,infosys,microsoft,hewlett packard are from business unit dimension

[swuehl]

I need to see how you have created the mixed dimension and how your data model looks like.

If you followed what Sunny has proposed, you can used the Dim dimension to color the background.

[ramchalla]

I am using only one table from the database and this table has required fields for reporting.

I am facing problems while sorting this grouping dimension and i need to provide different background colors to each dimension in this group.