String related to max value

Mon, 28 Jan 2013 15:17:10 GMT

Hi,

I have the following data in a pivot table:

My issue is to visualize Engine description (string) according to the max value of Measure, as in the below table.

MODEL	Segment	TYPE	SUB_TYPE	Engine	sum ( Measure )	max(TOTAL<TYPE,MODEL> aggr(sum(Measure),MODEL,TYPE,SUB_TYPE))
A4	D	A	A1	aaa	879	879
A4	D	A	A2	aaa	14	879
A4	D	A	A3	aaa	828	879
A4	D	A	A4	aaa	20	879
A4	D	A	A5	aaa	0	879
A4	D	A	A6	aaa	63	879
A4	D	A	A7	aaa	1	879
A4	D	B	B1	bbb	8	10
A4	D	B	B2	bbb	10	10
A4	D	B	B3	bbb	1	10
A4	D	B	B4	bbb	0	10
A4	D	B	B5	bbb	4	10
A4	D	B	B6	bbb	2	10
A4	D	B	B7	bbb	0	10

I got the max of the sum(Measure) grouped by Type, but I'm not able to visualize the correct string.

Could anyone help me?

Thanks a lot,

Davide

topic String related to max value in QlikView