topic Re: sort pivot table according a hide dimension in QlikView

sort pivot table according a hide dimension

Tue, 26 Mar 2013 09:50:36 GMT

Hi all,

I need to sort a pivot table according to 'Volumes' dimension without visualizing this dimension in pivot.

	BRAND	..\040-Images\Gif\Brand Images\AUDI.gif			..\040-Images\Gif\Brand Images\FIAT.gif	..\040-Images\Gif\Brand Images\MERCEDES.gif
	MODEL	A1	A3	A4	500L	A-CLASS
	Engine	2.0T DI 256 MT AWD	3.2 6V DI 250 DCT AWD	3.0 6L T DI 272 DCT AWD	0.9 2L T 105 MT	2.0T DI 211 DCT
CHR	Volumes	10054558	10065156	10064756	20001047	10032922
acceleration 0-100 km/h		8,3	7,4	6,1	12,3	6,6
CO2 level - g/km combined		108	169	197	112	143
Maximum power hp/PS		143	200	272	105	211
maximum speed (km/h)		217	238	250	180	240
maximum torque Nm		320	280	350	145	350
published kerb weight (kg)		1190	1335	1665	1260	1370
rpm for maximum power		-	-	4000	-	-
rpm for maximum torque		1750	1700	1500	2000	1200
urban (l/100km)		5	10	11,1	5,7	8,3

How can I achieve this results?

Thanks for help,

Davide

Re: sort pivot table according a hide dimension

Gysbert_Wassenaar — Tue, 26 Mar 2013 11:50:40 GMT

It looks like there's only one Volumes per MODEL. You could try changing MODEL to a calculated dimension: =dual(MODEL,Volumes) and sort MODEL numerically. If that's not possible with MODEL you could try it for Engine instead. If that doesn't work either you are totally out of luck. Pivot tables are very limited when it comes to sorting.

Re: sort pivot table according a hide dimension

Tue, 26 Mar 2013 13:48:37 GMT

Thanks,

I solved this problem with a workaround. I maintain the 'Volumes' dimension and hide it with a text object in which I set the title of the chart.

Thanks anyway.

Davide