Other visualization on pivot table

Wed, 22 May 2013 13:59:11 GMT

Hi,

I have the need to visualize the best value of a field on a specific dimension and also I need to visualize 'all other values' that are not included in the previous list.

I try to explain through an example.

I have the following data:

F1	F2	F3	F4
A	pippo	2	1
A	pluto	4	2
A	pap	6	3
B	cip	2	4
B	paperone	4	6
B	pippo	7	4
B	pluto	11	5
C	pippo	1	8
C	minni	3	6
C	pluto	4	7
C		5	2
C	ciop	5	5

I need to have the best value of F2 according to the value of F4, like below:

F1	FirstSortedValue({$<F2-={""}>}distinct F2,F4)
A	pippo
B	pippo
C	ciop

I need to visualize a fourth value for F1 ('Other') that contain all values of F2 except for the values already listed.

The result should be the following:

F1	FirstSortedValue({$<F2-={""}>}distinct F2,F4)
A	pippo
B	pippo
C	ciop
Other	pluto
	pap
	cip
	paperone
	minni

Any suggestion?

Thanks very much in advance.

Davide

topic Other visualization on pivot table in QlikView

Other visualization on pivot table