Key Brands Availability Comparision of LM vs L3M

[#1]

Hello All,

My requirement is to show the ''Key Brands Availability Comparision of LM vs L3M'' i am having different products,this should be shown in pivot table for example like this..

Key Brands Availability Comparision of LM vs L3M
product1	product1	product3	product4	product5	product6	product7	product8	product9	product10	product11	product12	product13	product14
65.20%	12.70%	33.40%	47.60%	15.50%	1.50%	2.10%	40.50%	61.80%	0.50%	4.00%	13.40%	0.10%	0.40%
95.80%			71.20%			52.70%	40.80%	77.30%		35.00%	31.20%
99.00%			97.40%					83.70%		75.60%	78.80%
100.00%			64.80%	1.10%			27.30%	92.00%		4.50%	17.00%
95.00%			61.50%	25.70%			36.90%	57.50%		0.60%	0.60%
88.60%	0.30%	98.70%	94.90%	27.30%			96.60%	96.60%	0.30%	29.30%	13.80%
30.90%		98.90%	77.70%	30.90%			91.60%	87.70%		6.10%	2.20%
13.20%		95.00%	43.00%	2.50%			76.00%	90.10%		2.50%
20.60%		99.50%	48.60%	9.30%			86.00%	80.40%
93.80%			61.10%	10.60%			54.00%	80.50%		3.50%
92.70%	16.80%		71.10%				41.70%	51.70%		11.20%	11.40%
97.00%			34.70%	61.00%			71.20%	97.50%		14.60%	41.10%
57.80%			10.20%	24.00%			20.00%	96.00%		25.00%	11.00%
56.60%			29.20%					92.50%		8.50%	37.70%
91.00%	97.70%	5.20%	93.90%		50.40%		79.70%	49.30%	5.50%	0.60%	7.80%		9.30%
80.30%	87.70%	0.20%	97.60%				4.30%	4.30%		0.30%	2.10%
49.30%		90.70%	60.10%				14.20%	35.40%		0.30%	2.90%
50.30%		59.50%	16.70%	0.20%			32.10%	36.10%		0.40%	0.90%
66.60%		31.80%	31.00%	0.80%			16.30%	22.80%		2.20%	3.30%
89.50%	82.50%	59.70%	85.30%	0.70%			63.70%	63.90%		0.40%	5.60%

can any one know how to get this type in pivot table.i am writing the expression but it is not getting the correct value.

Regards,

bar

[Jason_Michaelides]

Ok - that's what you want to get to. What structure is your data at the moment? Tables, fields etc?

[#3]

Hi Jason,

Thanks for ur Reply, I Mensioned in the column i.e.,Product1,product2,etc...these are all the fields in one table only.

You have any idea for writing the expression for these out put.

Regards,

bar.

[Jason_Michaelides]

But what about your LM and L3M measures? Do you have 2 columns for each product or 2 rows? Can post some sample data?

[#5]

Hi Jason,

I want to show like this with expressions and dimensions,product1,product2,etc...these are the fields in only one table.for ex. LM= March and L3M= Feb,Jan and Dec

Regards,

bar

[Jason_Michaelides]

Bar,

I can see what you want it to look like but please tell me whatthe data looks like now!  Please post some sample source data and your data model (Ctrl+T) from QlikView.

Cheers,

Jason