topic Help with If statement in script in QlikView

topic Help with If statement in script in QlikView https://community.qlik.com/t5/QlikView/Help-with-If-statement-in-script/m-p/1415503#M609738 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm working on a requirement where a field will have vaues and a '*'.</P><P>* means select every value in the field.</P><P></P><P><STRONG style="text-decoration: underline;">I/P:</STRONG></P><P><STRONG style="text-decoration: underline;"><BR /></STRONG></P><P>  </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 80px;"><TBODY><TR><TD height="25" width="80">ID</TD></TR><TR><TD align="right" height="25">1</TD></TR><TR><TD align="right" height="25">2</TD></TR><TR><TD align="right" height="25">3</TD></TR><TR><TD align="right" height="25">4</TD></TR><TR><TD align="right" height="25">5</TD></TR><TR><TD align="right" height="25">6</TD></TR><TR><TD height="25">*</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P><STRONG style="text-decoration: underline;">O/P: - Might be this?</STRONG></P><P></P><P>  </P><P></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="400" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"NaN","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 187px; height: 348px;"><TBODY><TR><TD height="25" width="80">ID</TD><TD width="80">New ID</TD></TR><TR><TD align="right" height="25">1</TD><TD align="right">1</TD></TR><TR><TD align="right" height="25">2</TD><TD align="right">2</TD></TR><TR><TD align="right" height="25">3</TD><TD align="right">3</TD></TR><TR><TD align="right" height="25">4</TD><TD align="right">4</TD></TR><TR><TD align="right" height="25">5</TD><TD align="right">5</TD></TR><TR><TD align="right" height="25">6</TD><TD align="right">6</TD></TR><TR><TD height="25">*</TD><TD align="right">1</TD></TR><TR><TD height="25">*</TD><TD align="right">2</TD></TR><TR><TD height="25">*</TD><TD align="right">3</TD></TR><TR><TD height="25">*</TD><TD align="right">4</TD></TR><TR><TD height="25">*</TD><TD align="right">5</TD></TR><TR><TD height="25">*</TD><TD align="right">6</TD></TR></TBODY></TABLE><P></P><P></P><P>Any help is highly appreciated.</P></BODY></HTML> Sat, 02 Dec 2017 18:12:12 GMT markgraham123 2017-12-02T18:12:12Z Help with If statement in script https://community.qlik.com/t5/QlikView/Help-with-If-statement-in-script/m-p/1415503#M609738 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm working on a requirement where a field will have vaues and a '*'.</P><P>* means select every value in the field.</P><P></P><P><STRONG style="text-decoration: underline;">I/P:</STRONG></P><P><STRONG style="text-decoration: underline;"><BR /></STRONG></P><P>  </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 80px;"><TBODY><TR><TD height="25" width="80">ID</TD></TR><TR><TD align="right" height="25">1</TD></TR><TR><TD align="right" height="25">2</TD></TR><TR><TD align="right" height="25">3</TD></TR><TR><TD align="right" height="25">4</TD></TR><TR><TD align="right" height="25">5</TD></TR><TR><TD align="right" height="25">6</TD></TR><TR><TD height="25">*</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P><STRONG style="text-decoration: underline;">O/P: - Might be this?</STRONG></P><P></P><P>  </P><P></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="400" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"NaN","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 187px; height: 348px;"><TBODY><TR><TD height="25" width="80">ID</TD><TD width="80">New ID</TD></TR><TR><TD align="right" height="25">1</TD><TD align="right">1</TD></TR><TR><TD align="right" height="25">2</TD><TD align="right">2</TD></TR><TR><TD align="right" height="25">3</TD><TD align="right">3</TD></TR><TR><TD align="right" height="25">4</TD><TD align="right">4</TD></TR><TR><TD align="right" height="25">5</TD><TD align="right">5</TD></TR><TR><TD align="right" height="25">6</TD><TD align="right">6</TD></TR><TR><TD height="25">*</TD><TD align="right">1</TD></TR><TR><TD height="25">*</TD><TD align="right">2</TD></TR><TR><TD height="25">*</TD><TD align="right">3</TD></TR><TR><TD height="25">*</TD><TD align="right">4</TD></TR><TR><TD height="25">*</TD><TD align="right">5</TD></TR><TR><TD height="25">*</TD><TD align="right">6</TD></TR></TBODY></TABLE><P></P><P></P><P>Any help is highly appreciated.</P></BODY></HTML> Sat, 02 Dec 2017 18:12:12 GMT https://community.qlik.com/t5/QlikView/Help-with-If-statement-in-script/m-p/1415503#M609738 markgraham123 2017-12-02T18:12:12Z Re: Help with If statement in script https://community.qlik.com/t5/QlikView/Help-with-If-statement-in-script/m-p/1415504#M609739 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>maybe helpful:</P><P></P><P style="font-size: 13.3333px;"><A href="https://community.qlik.com/docs/DOC-3451">Generic keys</A></P><P style="font-size: 13.3333px;"></P><P><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/download/3451-6-46406/Generic Keys.pdf" title="https://community.qlik.com/servlet/JiveServlet/download/3451-6-46406/Generic%20Keys.pdf">https://community.qlik.com/servlet/JiveServlet/download/3451-6-46406/Generic%20Keys.pdf</A></P><P>(see page 5ff.)</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 03 Dec 2017 23:14:59 GMT https://community.qlik.com/t5/QlikView/Help-with-If-statement-in-script/m-p/1415504#M609739 MarcoWedel 2017-12-03T23:14:59Z