topic Loop for testing different columns in App Development https://community.qlik.com/t5/App-Development/Loop-for-testing-different-columns/m-p/1454273#M35719 <HTML><HEAD></HEAD><BODY><P>Hi community !</P><P>I need your help,</P><P>In my script, i'd like to create a test on different type of date, and put a warning when the date is on Christmas or on the first of the year</P><P>I have five differents type of dates :</P><P></P><P>DATA :</P><TABLE border="1" class="jiveBorder" height="175" style="border: 1px solid #000000; width: 485px; height: 174px;" width="483"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG style="font-size: 10pt;">ID</STRONG></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step0</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Step2</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step5</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step9</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>1</P></TD><TD style="padding: 2px;">12/12/2017</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">01/01/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">13/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">12/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;">25/12/2017</TD><TD style="padding: 2px;">25/12/2017<TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY></TBODY></TABLE></TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD></TR><TR><TD style="padding: 2px;">...</TD><TD style="padding: 2px;">.....</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">n</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">12/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/11/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD></TR></TBODY></TABLE><P></P><P>What I want :</P><P></P><P>DATA :</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step0</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Step2</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step5</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step9</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Test</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>1</P></TD><TD style="padding: 2px;">12/12/2017</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;">ok</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000; font-size: 13.3333px;">01/01/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">13/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;">Warning Step0 it's 01/01 </TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">12/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">25/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">25/12/2017</SPAN><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY></TBODY></TABLE></TD><TD style="padding: 2px;">Warning Step5 it's 25/12 , Warning Step9 it's 01/01</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;">ok</TD></TR><TR><TD style="padding: 2px;">...</TD><TD style="padding: 2px;">.....</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">n</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">12/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/11/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017<BR /><BR /></SPAN></TD><TD style="padding: 2px;">ok</TD></TR></TBODY></TABLE><P></P><P>Do you&nbsp; have an idea ?</P><P></P><P>Thank you !</P><P>Victor</P></BODY></HTML> Thu, 11 Jan 2018 14:02:31 GMT victor_greffet 2018-01-11T14:02:31Z Loop for testing different columns https://community.qlik.com/t5/App-Development/Loop-for-testing-different-columns/m-p/1454273#M35719 <HTML><HEAD></HEAD><BODY><P>Hi community !</P><P>I need your help,</P><P>In my script, i'd like to create a test on different type of date, and put a warning when the date is on Christmas or on the first of the year</P><P>I have five differents type of dates :</P><P></P><P>DATA :</P><TABLE border="1" class="jiveBorder" height="175" style="border: 1px solid #000000; width: 485px; height: 174px;" width="483"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG style="font-size: 10pt;">ID</STRONG></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step0</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Step2</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step5</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step9</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>1</P></TD><TD style="padding: 2px;">12/12/2017</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">01/01/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">13/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">12/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;">25/12/2017</TD><TD style="padding: 2px;">25/12/2017<TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY></TBODY></TABLE></TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD></TR><TR><TD style="padding: 2px;">...</TD><TD style="padding: 2px;">.....</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">n</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">12/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/11/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD></TR></TBODY></TABLE><P></P><P>What I want :</P><P></P><P>DATA :</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step0</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Step2</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step5</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Step9</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Test</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>1</P></TD><TD style="padding: 2px;">12/12/2017</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;">ok</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"><SPAN style="color: #ff0000; font-size: 13.3333px;">01/01/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">13/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;">Warning Step0 it's 01/01 </TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">12/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">25/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;">25/12/2017</SPAN><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY></TBODY></TABLE></TD><TD style="padding: 2px;">Warning Step5 it's 25/12 , Warning Step9 it's 01/01</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;">ok</TD></TR><TR><TD style="padding: 2px;">...</TD><TD style="padding: 2px;">.....</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">n</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">12/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10/11/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">18/12/2017<BR /><BR /></SPAN></TD><TD style="padding: 2px;">ok</TD></TR></TBODY></TABLE><P></P><P>Do you&nbsp; have an idea ?</P><P></P><P>Thank you !</P><P>Victor</P></BODY></HTML> Thu, 11 Jan 2018 14:02:31 GMT https://community.qlik.com/t5/App-Development/Loop-for-testing-different-columns/m-p/1454273#M35719 victor_greffet 2018-01-11T14:02:31Z