topic Re: Date in QlikView https://community.qlik.com/t5/QlikView/Date/m-p/1348437#M840858 <HTML><HEAD></HEAD><BODY><P>Where are you trying to do this? Script or front end? Dimension or expression (if its in front end)?</P></BODY></HTML> Tue, 02 May 2017 10:56:18 GMT sunny_talwar 2017-05-02T10:56:18Z Date https://community.qlik.com/t5/QlikView/Date/m-p/1348435#M840856 <HTML><HEAD></HEAD><BODY><P>HI ,</P><P>I want display when there is no date , for which iam trying to write the below expression ...</P><P>if (Date=null,0) </P><P></P><P>to which it is giving error in expression , Can someone please suggest me how to write this </P><P></P><P></P><P>Thanks in Advance </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1348435#M840856 smilingjohn 2020-11-25T16:16:04Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1348436#M840857 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>if (<STRONG>IsNull</STRONG>(Date),0)</EM></SPAN></P><P></P><P>Or,</P><P></P><P><EM>If( Len(trim(Date))=0, 0)</EM></P></BODY></HTML> Tue, 02 May 2017 10:54:24 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1348436#M840857 tresB 2017-05-02T10:54:24Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1348437#M840858 <HTML><HEAD></HEAD><BODY><P>Where are you trying to do this? Script or front end? Dimension or expression (if its in front end)?</P></BODY></HTML> Tue, 02 May 2017 10:56:18 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1348437#M840858 sunny_talwar 2017-05-02T10:56:18Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1348438#M840859 <HTML><HEAD></HEAD><BODY><P>Front end it is an expression within the text object </P></BODY></HTML> Tue, 02 May 2017 11:14:39 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1348438#M840859 smilingjohn 2017-05-02T11:14:39Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1348439#M840860 <HTML><HEAD></HEAD><BODY><P>Have you tried <A href="https://community.qlik.com/people/tresesco">tresesco</A>‌'s suggestions? May be doing that will resolve your issues</P></BODY></HTML> Tue, 02 May 2017 11:16:33 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1348439#M840860 sunny_talwar 2017-05-02T11:16:33Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1348440#M840861 <HTML><HEAD></HEAD><BODY><P>May be this, Because you are talking about Text object</P><P></P><P><STRONG>If(IsNull(Date),0, Concat(Date,','))</STRONG></P></BODY></HTML> Tue, 02 May 2017 12:19:07 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1348440#M840861 Anil_Babu_Samineni 2017-05-02T12:19:07Z