https://community.qlik.com/t5/QlikView/If-condition-with-time-format/m-p/1682834#M592748 <P>Hi,</P><P>I want to implement the following:-</P><P>1. Where the time_of_receipt field in straight table is blank I want to replace with the word 'PNR' in the image attached.</P> Mon, 09 Mar 2020 11:04:29 GMT sakshikaul 2020-03-09T11:04:29Z https://community.qlik.com/t5/QlikView/If-condition-with-time-format/m-p/1682834#M592748 <P>Hi,</P><P>I want to implement the following:-</P><P>1. Where the time_of_receipt field in straight table is blank I want to replace with the word 'PNR' in the image attached.</P> Mon, 09 Mar 2020 11:04:29 GMT https://community.qlik.com/t5/QlikView/If-condition-with-time-format/m-p/1682834#M592748 sakshikaul 2020-03-09T11:04:29Z https://community.qlik.com/t5/QlikView/If-condition-with-time-format/m-p/1682836#M592749 <P>maye be :</P><LI-CODE lang="python">if(len(trim(time_of_receipt))&lt;1,'PNR',time_of_receipt) as time_of_receipt,</LI-CODE> Mon, 09 Mar 2020 11:16:51 GMT https://community.qlik.com/t5/QlikView/If-condition-with-time-format/m-p/1682836#M592749 Taoufiq_Zarra 2020-03-09T11:16:51Z