topic Re: View only Max Values across Pivot Table Dimension in QlikView App Developmenthttps://community.qlik.com/t5/QlikView-App-Development/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 GMTrubenmarin2020-01-11T12:01:29ZView only Max Values across Pivot Table Dimensionhttps://community.qlik.com/t5/QlikView-App-Development/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>Thu, 09 Jan 2020 23:51:41 GMThttps://community.qlik.com/t5/QlikView-App-Development/View-only-Max-Values-across-Pivot-Table-Dimension/m-p/1664271#M449037sidjustice2020-01-09T23:51:41ZRe: View only Max Values across Pivot Table Dimensionhttps://community.qlik.com/t5/QlikView-App-Development/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 GMThttps://community.qlik.com/t5/QlikView-App-Development/View-only-Max-Values-across-Pivot-Table-Dimension/m-p/1664681#M449076rubenmarin2020-01-11T12:01:29Z