https://community.qlik.com/t5/QlikView/View-only-Max-Values-across-Pivot-Table-Dimension/m-p/1664271#M449037 <P>Hi&nbsp;</P><P>I have data as shown in the Raw Table in the qlikview document attached.</P><P>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</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Mode</TD><TD>Skew1</TD><TD>V1</TD><TD>T1</TD><TD>Skew2</TD><TD>V2</TD><TD>T2</TD></TR><TR><TD>A</TD><TD>x</TD><TD>0.900</TD><TD>14.0</TD><TD>z</TD><TD>0.740</TD><TD>14.1</TD></TR><TR><TD>B</TD><TD>x</TD><TD>0.850</TD><TD>12.6</TD><TD>y</TD><TD>0.750</TD><TD>13.1</TD></TR></TBODY></TABLE><P>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.</P><P>Thanks for looking <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>Sid</P><P>&nbsp;</P> Sat, 16 Nov 2024 19:19:41 GMT sidjustice 2024-11-16T19:19:41Z https://community.qlik.com/t5/QlikView/View-only-Max-Values-across-Pivot-Table-Dimension/m-p/1664271#M449037 <P>Hi&nbsp;</P><P>I have data as shown in the Raw Table in the qlikview document attached.</P><P>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</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Mode</TD><TD>Skew1</TD><TD>V1</TD><TD>T1</TD><TD>Skew2</TD><TD>V2</TD><TD>T2</TD></TR><TR><TD>A</TD><TD>x</TD><TD>0.900</TD><TD>14.0</TD><TD>z</TD><TD>0.740</TD><TD>14.1</TD></TR><TR><TD>B</TD><TD>x</TD><TD>0.850</TD><TD>12.6</TD><TD>y</TD><TD>0.750</TD><TD>13.1</TD></TR></TBODY></TABLE><P>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.</P><P>Thanks for looking <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>Sid</P><P>&nbsp;</P> Sat, 16 Nov 2024 19:19:41 GMT https://community.qlik.com/t5/QlikView/View-only-Max-Values-across-Pivot-Table-Dimension/m-p/1664271#M449037 sidjustice 2024-11-16T19:19:41Z https://community.qlik.com/t5/QlikView/View-only-Max-Values-across-Pivot-Table-Dimension/m-p/1664681#M449076 <P>Hi Sid, I made a quick fix using an outer aggr, PFA.</P> Sat, 11 Jan 2020 12:01:29 GMT https://community.qlik.com/t5/QlikView/View-only-Max-Values-across-Pivot-Table-Dimension/m-p/1664681#M449076 rubenmarin 2020-01-11T12:01:29Z