topic Re: Replace date with the Null Value. in QlikView https://community.qlik.com/t5/QlikView/Replace-date-with-the-Null-Value/m-p/104426#M16457 <HTML><HEAD></HEAD><BODY><P>Look here</P><P><A href="https://community.qlik.com/thread/308411">Replace String Value to Null</A></P></BODY></HTML> Thu, 19 Jul 2018 11:47:50 GMT sunny_talwar 2018-07-19T11:47:50Z Replace date with the Null Value. https://community.qlik.com/t5/QlikView/Replace-date-with-the-Null-Value/m-p/104425#M16456 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; font-family: 'book antiqua', palatino;">Hi,</SPAN></P><P></P><P><SPAN style="font-family: 'book antiqua', palatino; font-size: 10pt;">Please fine the attached xls, </SPAN></P><P><SPAN style="font-family: 'book antiqua', palatino; font-size: 10pt;">where LinkKey field have 2 value - </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="409"><TBODY><TR><TD class="xl63" height="17" width="409"><SPAN style="font-family: 'book antiqua', palatino; font-size: 10pt;">RFKPI&gt;&gt;S7.5-MILESTONE|43280|RFKPI</SPAN></TD></TR></TBODY></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="409"><TBODY><TR><TD class="xl65" height="17" width="409"><SPAN style="font-family: 'book antiqua', palatino; font-size: 10pt;">RFKPI&gt;&gt;LEGACY&gt;&gt;BRING-UP|43266|RFKPI</SPAN></TD></TR></TBODY></TABLE><P><SPAN style="font-family: 'book antiqua', palatino; font-size: 10pt;"> </SPAN></P><P><SPAN style="font-family: 'book antiqua', palatino; font-size: 10pt;">Now I want to replace where the field =</SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="409"><TBODY><TR><TD class="xl65" height="17" width="409"><SPAN style="font-family: 'book antiqua', palatino; font-size: 10pt;">RFKPI&gt;&gt;S7.5-MILESTONE|43280|RFKPI</SPAN></TD></TR></TBODY></TABLE><P><SPAN style="font-family: 'book antiqua', palatino; font-size: 10pt;">replace with </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 260px;"><TBODY><TR><TD class="xl65" height="17" width="260"><P><SPAN style="font-family: 'book antiqua', palatino; font-size: 10pt;">RACE_CHART_WEEK_DATE</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="font-family: 'book antiqua', palatino; font-size: 10pt;">Null value.</SPAN></P><P></P><P><SPAN style="font-family: 'book antiqua', palatino; font-size: 10pt;">I don't where the RFKPI&gt;&gt;S7.5-MILESTONE|43280|RFKPI = Then RACE_CHART_WEEK_DATE = Null or Blank.</SPAN></P><P><SPAN style="font-size: 10pt; font-family: 'book antiqua', palatino;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; font-family: 'book antiqua', palatino;">Help.</SPAN></P><P></P><P><SPAN style="font-size: 10pt; font-family: 'book antiqua', palatino;">Thanks.</SPAN></P></BODY></HTML> Thu, 19 Jul 2018 09:14:57 GMT https://community.qlik.com/t5/QlikView/Replace-date-with-the-Null-Value/m-p/104425#M16456 sona_sa 2018-07-19T09:14:57Z Re: Replace date with the Null Value. https://community.qlik.com/t5/QlikView/Replace-date-with-the-Null-Value/m-p/104426#M16457 <HTML><HEAD></HEAD><BODY><P>Look here</P><P><A href="https://community.qlik.com/thread/308411">Replace String Value to Null</A></P></BODY></HTML> Thu, 19 Jul 2018 11:47:50 GMT https://community.qlik.com/t5/QlikView/Replace-date-with-the-Null-Value/m-p/104426#M16457 sunny_talwar 2018-07-19T11:47:50Z