View only Max Values across Pivot Table Dimension

[sidjustice]

Hi 

I have data as shown in the Raw Table in the qlikview document attached.

I would like to visualize it like below. where I see the skew1, V1 and T1 values for the Max T1 and on the same row view the skew2, V2 and T2 values for the Max T2

Mode	Skew1	V1	T1	Skew2	V2	T2
A	x	0.900	14.0	z	0.740	14.1
B	x	0.850	12.6	y	0.750	13.1

I was able to show only valid values but I had to use skew as a dimension and then it displays blank values for the ones that I do not want to display.

Thanks for looking 🙂

Sid

[rubenmarin · Accepted solution]

Hi Sid, I made a quick fix using an outer aggr, PFA.