topic Add Days only for selected data in QlikView https://community.qlik.com/t5/QlikView/Add-Days-only-for-selected-data/m-p/374629#M139517 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a table as below:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="243" style="border: 1px solid #000000; width: 399px;"><TBODY><TR><TH align="center" style="background-color: #6690bc; text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Description</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc; text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Type</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc; text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Expire Date</STRONG></SPAN></TH></TR><TR><TD>Description1</TD><TD>SC</TD><TD>12-05-2012</TD></TR><TR><TD>Description2</TD><TD>SC</TD><TD><P>12-05-2012</P></TD></TR><TR><TD>Description3</TD><TD>SF</TD><TD><P>12-05-2012</P></TD></TR><TR><TD>Description4</TD><TD>SS</TD><TD><P>12-05-2012</P></TD></TR><TR><TD>Description5</TD><TD>SC</TD><TD><P>12-05-2012</P></TD></TR><TR><TD>Description6</TD><TD>SF</TD><TD><P>12-05-2012</P></TD></TR></TBODY></TABLE><P></P><P>I would add in the script 14 days on the Expire date only on the records that have value SS. It is possible?</P><P></P><P>Thank you</P></BODY></HTML> Wed, 30 May 2012 13:01:38 GMT andyrebs 2012-05-30T13:01:38Z Add Days only for selected data https://community.qlik.com/t5/QlikView/Add-Days-only-for-selected-data/m-p/374629#M139517 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a table as below:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="243" style="border: 1px solid #000000; width: 399px;"><TBODY><TR><TH align="center" style="background-color: #6690bc; text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Description</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc; text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Type</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc; text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Expire Date</STRONG></SPAN></TH></TR><TR><TD>Description1</TD><TD>SC</TD><TD>12-05-2012</TD></TR><TR><TD>Description2</TD><TD>SC</TD><TD><P>12-05-2012</P></TD></TR><TR><TD>Description3</TD><TD>SF</TD><TD><P>12-05-2012</P></TD></TR><TR><TD>Description4</TD><TD>SS</TD><TD><P>12-05-2012</P></TD></TR><TR><TD>Description5</TD><TD>SC</TD><TD><P>12-05-2012</P></TD></TR><TR><TD>Description6</TD><TD>SF</TD><TD><P>12-05-2012</P></TD></TR></TBODY></TABLE><P></P><P>I would add in the script 14 days on the Expire date only on the records that have value SS. It is possible?</P><P></P><P>Thank you</P></BODY></HTML> Wed, 30 May 2012 13:01:38 GMT https://community.qlik.com/t5/QlikView/Add-Days-only-for-selected-data/m-p/374629#M139517 andyrebs 2012-05-30T13:01:38Z Add Days only for selected data https://community.qlik.com/t5/QlikView/Add-Days-only-for-selected-data/m-p/374630#M139518 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P><EM>LOAD </EM></P><P><EM>Description,</EM></P><P><EM>Type,</EM></P><P><EM>if(Type = 'SS', date([Expire Date]+14),date([Expire Date]) ) as [Expire Date],</EM></P><P><EM>...</EM></P><P><EM>from Table;</EM></P><P></P><P>Your Expire Date must be read in as date type (adjust your standard date format if needed).</P><P></P><P>hope this helps,</P><P>Stefan</P></BODY></HTML> Wed, 30 May 2012 13:05:54 GMT https://community.qlik.com/t5/QlikView/Add-Days-only-for-selected-data/m-p/374630#M139518 swuehl 2012-05-30T13:05:54Z