topic Max value per series in script? in QlikView https://community.qlik.com/t5/QlikView/Max-value-per-series-in-script/m-p/850251#M992692 <HTML><HEAD></HEAD><BODY><P>Hi all I think this shouldnt be complicated but I cant quite figure out how to do this one, i have the following,</P><P></P><TABLE border="1" class="jiveBorder" height="206" style="border: 1px solid #000000; width: 272px; height: 207px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">incident</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>date<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>status<BR /></STRONG></TH></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">01/01/2015 12:00</TD><TD style="padding: 2px;">open</TD></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;"><P>01/01/2015 13:00</P></TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">01/01/2015 14:00</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">01/01/2015 15:00</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">BBB</TD><TD style="padding: 2px;">01/01/2015 13:30</TD><TD style="padding: 2px;">open</TD></TR><TR><TD>BBB</TD><TD>01/01/2015 14:10</TD><TD>-</TD></TR><TR><TD>BBB</TD><TD>01/01/2015 14:40</TD><TD>-</TD></TR></TBODY></TABLE><P></P><P></P><TABLE border="1" class="jiveBorder" height="105" style="border: 1px solid #000000; width: 189px; height: 106px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>incident<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>lateststatus<BR /></STRONG></TH></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">hold</TD></TR><TR><TD style="padding: 2px;">BBB</TD><TD style="padding: 2px;">pause</TD></TR></TBODY></TABLE><P></P><P></P><P>Now what i want is quite simple, I have left joined these 2 tables, and what I would like is, for the first table, if the last record for each incident is empty, use the lateststatus as status, so the outcome would be this.</P><P></P><P>This needs to be done in script please,</P><P></P><TABLE border="1" class="jiveBorder" height="206"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">incident</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>date<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>status<BR /></STRONG></TH></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">01/01/2015 12:00</TD><TD style="padding: 2px;">open</TD></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;"><P>01/01/2015 13:00</P></TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">01/01/2015 14:00</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">01/01/2015 15:00</TD><TD style="padding: 2px;">hold</TD></TR><TR><TD style="padding: 2px;">BBB</TD><TD style="padding: 2px;">01/01/2015 13:30</TD><TD style="padding: 2px;">open</TD></TR><TR><TD>BBB</TD><TD>01/01/2015 14:10</TD><TD>-</TD></TR><TR><TD>BBB</TD><TD>01/01/2015 14:40</TD><TD>pause</TD></TR></TBODY></TABLE><P></P><P></P><P>Many Thanks</P></BODY></HTML> Fri, 10 Jul 2015 21:58:08 GMT 2015-07-10T21:58:08Z Max value per series in script? https://community.qlik.com/t5/QlikView/Max-value-per-series-in-script/m-p/850251#M992692 <HTML><HEAD></HEAD><BODY><P>Hi all I think this shouldnt be complicated but I cant quite figure out how to do this one, i have the following,</P><P></P><TABLE border="1" class="jiveBorder" height="206" style="border: 1px solid #000000; width: 272px; height: 207px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">incident</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>date<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>status<BR /></STRONG></TH></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">01/01/2015 12:00</TD><TD style="padding: 2px;">open</TD></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;"><P>01/01/2015 13:00</P></TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">01/01/2015 14:00</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">01/01/2015 15:00</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">BBB</TD><TD style="padding: 2px;">01/01/2015 13:30</TD><TD style="padding: 2px;">open</TD></TR><TR><TD>BBB</TD><TD>01/01/2015 14:10</TD><TD>-</TD></TR><TR><TD>BBB</TD><TD>01/01/2015 14:40</TD><TD>-</TD></TR></TBODY></TABLE><P></P><P></P><TABLE border="1" class="jiveBorder" height="105" style="border: 1px solid #000000; width: 189px; height: 106px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>incident<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>lateststatus<BR /></STRONG></TH></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">hold</TD></TR><TR><TD style="padding: 2px;">BBB</TD><TD style="padding: 2px;">pause</TD></TR></TBODY></TABLE><P></P><P></P><P>Now what i want is quite simple, I have left joined these 2 tables, and what I would like is, for the first table, if the last record for each incident is empty, use the lateststatus as status, so the outcome would be this.</P><P></P><P>This needs to be done in script please,</P><P></P><TABLE border="1" class="jiveBorder" height="206"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">incident</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>date<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>status<BR /></STRONG></TH></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">01/01/2015 12:00</TD><TD style="padding: 2px;">open</TD></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;"><P>01/01/2015 13:00</P></TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">01/01/2015 14:00</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">AAA</TD><TD style="padding: 2px;">01/01/2015 15:00</TD><TD style="padding: 2px;">hold</TD></TR><TR><TD style="padding: 2px;">BBB</TD><TD style="padding: 2px;">01/01/2015 13:30</TD><TD style="padding: 2px;">open</TD></TR><TR><TD>BBB</TD><TD>01/01/2015 14:10</TD><TD>-</TD></TR><TR><TD>BBB</TD><TD>01/01/2015 14:40</TD><TD>pause</TD></TR></TBODY></TABLE><P></P><P></P><P>Many Thanks</P></BODY></HTML> Fri, 10 Jul 2015 21:58:08 GMT https://community.qlik.com/t5/QlikView/Max-value-per-series-in-script/m-p/850251#M992692 2015-07-10T21:58:08Z Re: Max value per series in script? https://community.qlik.com/t5/QlikView/Max-value-per-series-in-script/m-p/850252#M992693 <HTML><HEAD></HEAD><BODY><P>Hi Gualter,</P><P>see attachment.</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Fri, 10 Jul 2015 22:40:51 GMT https://community.qlik.com/t5/QlikView/Max-value-per-series-in-script/m-p/850252#M992693 antoniotiman 2015-07-10T22:40:51Z