topic Previous action in QlikView https://community.qlik.com/t5/QlikView/Previous-action/m-p/209839#M64669 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt;">I have a table with historic data where I need to set flags in load script if certain conditions are fulfilled.</P><P style="margin: 0cm 0cm 0pt;"></P><TABLE border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 480; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext;"><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><TD style="padding-right: 5.4pt; padding-left: 5.4pt; padding-bottom: 0cm; width: 86.4pt; padding-top: 0cm; background-color: transparent; mso-border-alt: solid windowtext .5pt; border: windowtext 1pt solid;" valign="top" width="115"><P style="margin: 0cm 0cm 0pt;">Date</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: windowtext 1pt solid; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 81pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" valign="top" width="108"><P style="margin: 0cm 0cm 0pt;">Action</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: windowtext 1pt solid; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 306pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" valign="top" width="408"><P style="margin: 0cm 0cm 0pt;"></P></TD></TR><TR style="mso-yfti-irow: 1;"><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 86.4pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="115"><P style="margin: 0cm 0cm 0pt;">03/01-2011</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 81pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="108"><P style="font-weight: bold; margin: 0cm 0cm 0pt; mso-bidi-font-weight: normal">REJUR</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 306pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="408"><P style="font-weight: bold; margin: 0cm 0cm 0pt; mso-bidi-font-weight: normal"></P></TD></TR><TR style="mso-yfti-irow: 2;"><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 86.4pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="115"><P style="margin: 0cm 0cm 0pt;">06/01-2011</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 81pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="108"><P style="margin: 0cm 0cm 0pt;">AS</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 306pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="408"><P style="margin: 0cm 0cm 0pt;"></P></TD></TR><TR style="mso-yfti-irow: 3;"><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 86.4pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="115"><P style="margin: 0cm 0cm 0pt;">09/01-2011</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 81pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="108"><P style="margin: 0cm 0cm 0pt;">COME</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 306pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="408"><P style="margin: 0cm 0cm 0pt;"></P></TD></TR><TR style="mso-yfti-irow: 4;"><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 86.4pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="115"><P style="margin: 0cm 0cm 0pt;">15/01-2011</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 81pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="108"><P style="font-weight: bold; margin: 0cm 0cm 0pt; mso-bidi-font-weight: normal">READV</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 306pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="408"><P style="margin: 0cm 0cm 0pt;">I need to set flag here because REJUR is above and REJUR date &gt;01/01-2011</P></TD></TR><TR style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 86.4pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="115"><P style="margin: 0cm 0cm 0pt;">16/01-2011</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 81pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="108"><P style="font-weight: bold; margin: 0cm 0cm 0pt; mso-bidi-font-weight: normal">REFGD</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 306pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="408"><P style="margin: 0cm 0cm 0pt;">I need to set flag here because REJUR is above and REJUR date &gt;01/01-2011<B style="mso-bidi-font-weight: normal;"></B></P></TD></TR></TBODY></TABLE><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">My problem is that there can be 0, 1, 2, 3, ….. 999 actions between REJUR and the other RE* and I need to flag the RE* if REJUR is above and REJUR date is greater than 01/01-2011.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">Any ideas ?</P></BODY></HTML> Thu, 10 Feb 2011 11:28:49 GMT 2011-02-10T11:28:49Z Previous action https://community.qlik.com/t5/QlikView/Previous-action/m-p/209839#M64669 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt;">I have a table with historic data where I need to set flags in load script if certain conditions are fulfilled.</P><P style="margin: 0cm 0cm 0pt;"></P><TABLE border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 480; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext;"><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><TD style="padding-right: 5.4pt; padding-left: 5.4pt; padding-bottom: 0cm; width: 86.4pt; padding-top: 0cm; background-color: transparent; mso-border-alt: solid windowtext .5pt; border: windowtext 1pt solid;" valign="top" width="115"><P style="margin: 0cm 0cm 0pt;">Date</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: windowtext 1pt solid; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 81pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" valign="top" width="108"><P style="margin: 0cm 0cm 0pt;">Action</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: windowtext 1pt solid; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 306pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt;" valign="top" width="408"><P style="margin: 0cm 0cm 0pt;"></P></TD></TR><TR style="mso-yfti-irow: 1;"><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 86.4pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="115"><P style="margin: 0cm 0cm 0pt;">03/01-2011</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 81pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="108"><P style="font-weight: bold; margin: 0cm 0cm 0pt; mso-bidi-font-weight: normal">REJUR</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 306pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="408"><P style="font-weight: bold; margin: 0cm 0cm 0pt; mso-bidi-font-weight: normal"></P></TD></TR><TR style="mso-yfti-irow: 2;"><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 86.4pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="115"><P style="margin: 0cm 0cm 0pt;">06/01-2011</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 81pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="108"><P style="margin: 0cm 0cm 0pt;">AS</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 306pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="408"><P style="margin: 0cm 0cm 0pt;"></P></TD></TR><TR style="mso-yfti-irow: 3;"><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 86.4pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="115"><P style="margin: 0cm 0cm 0pt;">09/01-2011</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 81pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="108"><P style="margin: 0cm 0cm 0pt;">COME</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 306pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="408"><P style="margin: 0cm 0cm 0pt;"></P></TD></TR><TR style="mso-yfti-irow: 4;"><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 86.4pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="115"><P style="margin: 0cm 0cm 0pt;">15/01-2011</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 81pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="108"><P style="font-weight: bold; margin: 0cm 0cm 0pt; mso-bidi-font-weight: normal">READV</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 306pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="408"><P style="margin: 0cm 0cm 0pt;">I need to set flag here because REJUR is above and REJUR date &gt;01/01-2011</P></TD></TR><TR style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 86.4pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="115"><P style="margin: 0cm 0cm 0pt;">16/01-2011</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 81pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="108"><P style="font-weight: bold; margin: 0cm 0cm 0pt; mso-bidi-font-weight: normal">REFGD</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 5.4pt; border-top: #d4d0c8; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #d4d0c8; width: 306pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; background-color: transparent; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt;" valign="top" width="408"><P style="margin: 0cm 0cm 0pt;">I need to set flag here because REJUR is above and REJUR date &gt;01/01-2011<B style="mso-bidi-font-weight: normal;"></B></P></TD></TR></TBODY></TABLE><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">My problem is that there can be 0, 1, 2, 3, ….. 999 actions between REJUR and the other RE* and I need to flag the RE* if REJUR is above and REJUR date is greater than 01/01-2011.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">Any ideas ?</P></BODY></HTML> Thu, 10 Feb 2011 11:28:49 GMT https://community.qlik.com/t5/QlikView/Previous-action/m-p/209839#M64669 2011-02-10T11:28:49Z