topic association help needed! in QlikView https://community.qlik.com/t5/QlikView/association-help-needed/m-p/145289#M24022 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I'm hoping you can hep with my query. I'm looking to associate events as outlined below:</P><DIV><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 454pt; border-collapse: collapse;" width="606"><COLGROUP><COL style="width: 116pt; mso-width-source: userset; mso-width-alt: 5668; mso-outline-parent: collapsed;" width="155" /><COL style="width: 113pt; mso-width-source: userset; mso-width-alt: 5522; mso-outline-parent: collapsed;" width="151" /><COL style="width: 164pt; mso-width-source: userset; mso-width-alt: 8009; mso-outline-parent: collapsed;" width="219" /><COL style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962; mso-outline-parent: collapsed;" width="81" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl24" height="17" style="width: 116pt; height: 12.75pt; background-color: #ebebeb; border: gainsboro 0.5pt solid;" width="155"><STRONG>StartDate</STRONG></TD><TD class="xl24" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro 0.5pt solid; border-left: gainsboro; width: 113pt; border-bottom: gainsboro 0.5pt solid; background-color: #ebebeb;" width="151"><STRONG>node</STRONG></TD><TD class="xl24" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro 0.5pt solid; border-left: gainsboro; width: 164pt; border-bottom: gainsboro 0.5pt solid; background-color: #ebebeb;" width="219"><STRONG>varname</STRONG></TD><TD class="xl24" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro 0.5pt solid; border-left: gainsboro; width: 61pt; border-bottom: gainsboro 0.5pt solid; background-color: #ebebeb;" width="81"><STRONG>SeverityDesc</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;" num="39757.596273148149">05/11/2008 14:18:38</TD><TD class="xl25" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">A</TD><TD class="xl25" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">B</TD><TD class="xl25" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">WARN</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;" num="39757.596967592595">05/11/2008 14:19:38</TD><TD class="xl26" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">A</TD><TD class="xl26" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">B</TD><TD class="xl26" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">CRITICAL</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl27" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: whitesmoke;" num="39757.597199074073">05/11/2008 14:19:58</TD><TD class="xl28" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: whitesmoke;">A</TD><TD class="xl28" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: whitesmoke;">B</TD><TD class="xl28" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: whitesmoke;">OK</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;" num="39757.596967592595">05/11/2008 14:19:38</TD><TD class="xl26" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">B</TD><TD class="xl26" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">B</TD><TD class="xl26" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">CRITICAL</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl27" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: whitesmoke;" num="39757.597199074073">05/11/2008 14:19:58</TD><TD class="xl28" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: whitesmoke;">B</TD><TD class="xl28" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: whitesmoke;">B</TD><TD class="xl28" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: whitesmoke;">OK</TD></TR></TBODY></TABLE></DIV><DIV></DIV><DIV><DIV>If a WARN is found for a node and varname then the next CRITICAL or OK should be associated with it.</DIV><DIV>If a CRITICAL is found the next OK should be associated with it.</DIV><DIV></DIV><DIV>I am trying to calculate the duration of the event from WARN or CRITICAL to OK</DIV><DIV></DIV><DIV>Any thoughts guys?</DIV><DIV></DIV><DIV>Thanks for help:</DIV><DIV></DIV><DIV>bc</DIV></DIV></BODY></HTML> Thu, 28 May 2009 17:26:20 GMT 2009-05-28T17:26:20Z association help needed! https://community.qlik.com/t5/QlikView/association-help-needed/m-p/145289#M24022 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I'm hoping you can hep with my query. I'm looking to associate events as outlined below:</P><DIV><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 454pt; border-collapse: collapse;" width="606"><COLGROUP><COL style="width: 116pt; mso-width-source: userset; mso-width-alt: 5668; mso-outline-parent: collapsed;" width="155" /><COL style="width: 113pt; mso-width-source: userset; mso-width-alt: 5522; mso-outline-parent: collapsed;" width="151" /><COL style="width: 164pt; mso-width-source: userset; mso-width-alt: 8009; mso-outline-parent: collapsed;" width="219" /><COL style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962; mso-outline-parent: collapsed;" width="81" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl24" height="17" style="width: 116pt; height: 12.75pt; background-color: #ebebeb; border: gainsboro 0.5pt solid;" width="155"><STRONG>StartDate</STRONG></TD><TD class="xl24" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro 0.5pt solid; border-left: gainsboro; width: 113pt; border-bottom: gainsboro 0.5pt solid; background-color: #ebebeb;" width="151"><STRONG>node</STRONG></TD><TD class="xl24" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro 0.5pt solid; border-left: gainsboro; width: 164pt; border-bottom: gainsboro 0.5pt solid; background-color: #ebebeb;" width="219"><STRONG>varname</STRONG></TD><TD class="xl24" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro 0.5pt solid; border-left: gainsboro; width: 61pt; border-bottom: gainsboro 0.5pt solid; background-color: #ebebeb;" width="81"><STRONG>SeverityDesc</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;" num="39757.596273148149">05/11/2008 14:18:38</TD><TD class="xl25" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">A</TD><TD class="xl25" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">B</TD><TD class="xl25" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">WARN</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;" num="39757.596967592595">05/11/2008 14:19:38</TD><TD class="xl26" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">A</TD><TD class="xl26" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">B</TD><TD class="xl26" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">CRITICAL</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl27" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: whitesmoke;" num="39757.597199074073">05/11/2008 14:19:58</TD><TD class="xl28" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: whitesmoke;">A</TD><TD class="xl28" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: whitesmoke;">B</TD><TD class="xl28" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: whitesmoke;">OK</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl25" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: white;" num="39757.596967592595">05/11/2008 14:19:38</TD><TD class="xl26" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">B</TD><TD class="xl26" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">B</TD><TD class="xl26" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: white;">CRITICAL</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl27" height="17" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro 0.5pt solid; border-bottom: gainsboro 0.5pt solid; height: 12.75pt; background-color: whitesmoke;" num="39757.597199074073">05/11/2008 14:19:58</TD><TD class="xl28" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: whitesmoke;">B</TD><TD class="xl28" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: whitesmoke;">B</TD><TD class="xl28" style="border-right: gainsboro 0.5pt solid; border-top: gainsboro; border-left: gainsboro; border-bottom: gainsboro 0.5pt solid; background-color: whitesmoke;">OK</TD></TR></TBODY></TABLE></DIV><DIV></DIV><DIV><DIV>If a WARN is found for a node and varname then the next CRITICAL or OK should be associated with it.</DIV><DIV>If a CRITICAL is found the next OK should be associated with it.</DIV><DIV></DIV><DIV>I am trying to calculate the duration of the event from WARN or CRITICAL to OK</DIV><DIV></DIV><DIV>Any thoughts guys?</DIV><DIV></DIV><DIV>Thanks for help:</DIV><DIV></DIV><DIV>bc</DIV></DIV></BODY></HTML> Thu, 28 May 2009 17:26:20 GMT https://community.qlik.com/t5/QlikView/association-help-needed/m-p/145289#M24022 2009-05-28T17:26:20Z association help needed! https://community.qlik.com/t5/QlikView/association-help-needed/m-p/145290#M24023 <HTML><HEAD></HEAD><BODY><P>There's probably a better way, but the attached seems to work.</P></BODY></HTML> Sat, 30 May 2009 02:22:28 GMT https://community.qlik.com/t5/QlikView/association-help-needed/m-p/145290#M24023 johnw 2009-05-30T02:22:28Z