topic Re: Get the Max Value for Each Row over 3 Fields in QlikView https://community.qlik.com/t5/QlikView/Get-the-Max-Value-for-Each-Row-over-3-Fields/m-p/731989#M1055047 <HTML><HEAD></HEAD><BODY><P>Not Clear with the question.. can you be clear and if possible can you attach app?</P></BODY></HTML> Wed, 15 Oct 2014 14:50:28 GMT ychaitanya 2014-10-15T14:50:28Z Get the Max Value for Each Row over 3 Fields https://community.qlik.com/t5/QlikView/Get-the-Max-Value-for-Each-Row-over-3-Fields/m-p/731988#M1055046 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following table:</P><P></P><P dir="ltr"><SPAN dir="ltr" style="font-family: 'Segoe UI'; color: #000000; font-size: 10pt;"></SPAN></P><TABLE cellpadding="3" cellspacing="0"><TBODY><TR><TD style="text-align: center; background-color: whitesmoke; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border: silver 0.5pt solid;"><STRONG>ak<SPAN style="color: black; border-color: black;"> </SPAN></STRONG></TD><TD style="border-bottom: silver 0.5pt solid; text-align: center; border-left: silver; background-color: whitesmoke; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver 0.5pt solid; border-right: silver 0.5pt solid;"><STRONG>atd<SPAN style="color: black; border-color: black;"> </SPAN></STRONG></TD><TD style="border-bottom: silver 0.5pt solid; text-align: center; border-left: silver; background-color: whitesmoke; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver 0.5pt solid; border-right: silver 0.5pt solid;"><STRONG>bk<SPAN style="color: black; border-color: black;"> </SPAN></STRONG></TD><TD style="border-bottom: silver 0.5pt solid; text-align: center; border-left: silver; background-color: whitesmoke; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver 0.5pt solid; border-right: silver 0.5pt solid;"><STRONG>btd<SPAN style="color: black; border-color: black;"> </SPAN></STRONG></TD><TD style="border-bottom: silver 0.5pt solid; text-align: center; border-left: silver; background-color: whitesmoke; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver 0.5pt solid; border-right: silver 0.5pt solid;"><STRONG>ck<SPAN style="color: black; border-color: black;"> </SPAN></STRONG></TD><TD style="border-bottom: silver 0.5pt solid; text-align: center; border-left: silver; background-color: whitesmoke; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver 0.5pt solid; border-right: silver 0.5pt solid;"><STRONG>ctd<SPAN style="color: black; border-color: black;"> </SPAN></STRONG></TD></TR><TR><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver 0.5pt solid; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">15</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">17/05/2013</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">10</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">19/02/2013</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">3,68</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">09/02/2013</TD></TR><TR><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver 0.5pt solid; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">3</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">01/07/2013</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">7</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">10/04/2013</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">4,02</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">23/03/2013</TD></TR><TR><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver 0.5pt solid; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">25</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">24/07/2013</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">38</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">22/06/2013</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">3,89</TD><TD style="border-bottom: silver 0.5pt solid; text-align: right; border-left: silver; background-color: white; font-family: Calibri, sans-serif; color: #363636; font-size: 9pt; border-top: silver; border-right: silver 0.5pt solid;">15/08/2013</TD></TR></TBODY></TABLE><P></P><UL><LI>ak (value) &amp; atd (date: DD/MM/YYYY)</LI><LI>bk (value) &amp; btd (date: DD/MM/YYYY)</LI><LI>ck (value) &amp; ctd (date: DD/MM/YYYY)</LI></UL><P></P><P>What I need is to get the max value for each row and the corresponding date.</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">That means I should get something like the following:</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="175"><TBODY><TR><TD class="xl67" height="20" width="80">value</TD><TD class="xl68" width="95">date</TD></TR><TR><TD class="xl69" height="20" width="80">15</TD><TD class="xl65" width="95">17/05/2013</TD></TR><TR><TD class="xl66" height="20" width="80">7</TD><TD class="xl65" width="95">10/04/2013</TD></TR><TR><TD class="xl71" height="21" width="80">38</TD><TD class="xl70" width="95">22/06/2013</TD></TR></TBODY></TABLE><P></P><P>Is there any way to do that?</P><P></P><P>Thank you!!!</P></BODY></HTML> Wed, 15 Oct 2014 14:41:16 GMT https://community.qlik.com/t5/QlikView/Get-the-Max-Value-for-Each-Row-over-3-Fields/m-p/731988#M1055046 2014-10-15T14:41:16Z Re: Get the Max Value for Each Row over 3 Fields https://community.qlik.com/t5/QlikView/Get-the-Max-Value-for-Each-Row-over-3-Fields/m-p/731989#M1055047 <HTML><HEAD></HEAD><BODY><P>Not Clear with the question.. can you be clear and if possible can you attach app?</P></BODY></HTML> Wed, 15 Oct 2014 14:50:28 GMT https://community.qlik.com/t5/QlikView/Get-the-Max-Value-for-Each-Row-over-3-Fields/m-p/731989#M1055047 ychaitanya 2014-10-15T14:50:28Z Re: Get the Max Value for Each Row over 3 Fields https://community.qlik.com/t5/QlikView/Get-the-Max-Value-for-Each-Row-over-3-Fields/m-p/731990#M1055048 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>You can use RangeMax(max(ak),max(bk),max(ck)) for the max of each of the 3 columns.</P></BODY></HTML> Wed, 15 Oct 2014 14:52:43 GMT https://community.qlik.com/t5/QlikView/Get-the-Max-Value-for-Each-Row-over-3-Fields/m-p/731990#M1055048 2014-10-15T14:52:43Z Re: Get the Max Value for Each Row over 3 Fields https://community.qlik.com/t5/QlikView/Get-the-Max-Value-for-Each-Row-over-3-Fields/m-p/731991#M1055049 <HTML><HEAD></HEAD><BODY><P>I have this table and I need to get only the values in bold:</P><P></P><DIV><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 525px;"><TBODY><TR><TD class="xl67" height="20" width="80">ak</TD><TD class="xl68" width="95">atd</TD><TD class="xl68" width="80">bk</TD><TD class="xl68" width="95">btd</TD><TD class="xl68" width="80">ck</TD><TD class="xl69" width="95">ctd</TD></TR><TR><TD class="xl76" height="20" width="80"><STRONG style="text-decoration: underline;">15</STRONG></TD><TD class="xl77" width="95"><STRONG style="text-decoration: underline;">17/05/2013</STRONG></TD><TD class="xl66" width="80">10</TD><TD class="xl65" width="95">19/02/2013</TD><TD class="xl66" width="80">3,68</TD><TD class="xl71" width="95">09/02/2013</TD></TR><TR><TD class="xl70" height="20" width="80">3</TD><TD class="xl65" width="95">01/07/2013</TD><TD class="xl78" width="80"><STRONG style="text-decoration: underline;">7</STRONG></TD><TD class="xl77" width="95"><STRONG style="text-decoration: underline;">10/04/2013</STRONG></TD><TD class="xl66" width="80">4,02</TD><TD class="xl71" width="95">23/03/2013</TD></TR><TR><TD class="xl72" height="21" width="80">25</TD><TD class="xl73" width="95">24/07/2013</TD><TD class="xl79" width="80"><STRONG style="text-decoration: underline;">38</STRONG></TD><TD class="xl80" width="95">22/06/2013</TD><TD class="xl74" width="80">3,89</TD><TD class="xl75" width="95">15/08/2013</TD></TR></TBODY></TABLE></DIV><DIV> </DIV></BODY></HTML> Wed, 15 Oct 2014 14:57:04 GMT https://community.qlik.com/t5/QlikView/Get-the-Max-Value-for-Each-Row-over-3-Fields/m-p/731991#M1055049 2014-10-15T14:57:04Z Re: Get the Max Value for Each Row over 3 Fields https://community.qlik.com/t5/QlikView/Get-the-Max-Value-for-Each-Row-over-3-Fields/m-p/731992#M1055050 <HTML><HEAD></HEAD><BODY><P>your asking max value but in first row 25 is the max&nbsp; but u highlighted 15?</P></BODY></HTML> Wed, 15 Oct 2014 15:04:00 GMT https://community.qlik.com/t5/QlikView/Get-the-Max-Value-for-Each-Row-over-3-Fields/m-p/731992#M1055050 2014-10-15T15:04:00Z Re: Get the Max Value for Each Row over 3 Fields https://community.qlik.com/t5/QlikView/Get-the-Max-Value-for-Each-Row-over-3-Fields/m-p/731993#M1055051 <HTML><HEAD></HEAD><BODY><P>Yes but the max is per row, not per column, that's why.</P><P></P><P>Max1: </P><TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl67" height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="80">ak</TD><TD class="xl68" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="95">atd</TD><TD class="xl68" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="80">bk</TD><TD class="xl68" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="95">btd</TD><TD class="xl68" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="80">ck</TD><TD class="xl69" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="95">ctd</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl76" height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="80"><STRONG style="font-style: inherit; font-family: inherit; text-decoration: underline;">15</STRONG></TD><TD class="xl77" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="95"><STRONG style="font-style: inherit; font-family: inherit; text-decoration: underline;">17/05/2013</STRONG></TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="80">10</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="95">19/02/2013</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="80">3,68</TD><TD class="xl71" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="95">09/02/2013</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 15 Oct 2014 15:57:36 GMT https://community.qlik.com/t5/QlikView/Get-the-Max-Value-for-Each-Row-over-3-Fields/m-p/731993#M1055051 2014-10-15T15:57:36Z