topic Solved in QlikView https://community.qlik.com/t5/QlikView/Solved/m-p/982677#M949661 <HTML><HEAD></HEAD><BODY><P>Solved</P></BODY></HTML> Wed, 09 Dec 2015 14:57:06 GMT microwin88x 2015-12-09T14:57:06Z Solved https://community.qlik.com/t5/QlikView/Solved/m-p/982677#M949661 <HTML><HEAD></HEAD><BODY><P>Solved</P></BODY></HTML> Wed, 09 Dec 2015 14:57:06 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/982677#M949661 microwin88x 2015-12-09T14:57:06Z Re: Convert Null Values (hh:mm:ss) to 00:00:00 https://community.qlik.com/t5/QlikView/Solved/m-p/982678#M949662 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Time(If(Len(Trim(TimeField)) = 0, 0, TimeField), 'hh:mm:ss')</STRONG></P></BODY></HTML> Wed, 09 Dec 2015 14:58:15 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/982678#M949662 sunny_talwar 2015-12-09T14:58:15Z Re: Convert Null Values (hh:mm:ss) to 00:00:00 https://community.qlik.com/t5/QlikView/Solved/m-p/982679#M949663 <HTML><HEAD></HEAD><BODY><P>Share a sample file or you can do some think this ways</P><P></P><P>&nbsp; <STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">LOAD</STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> *,</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">IsNull</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Col</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">) = -1 </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">or</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Len</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Col</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)=1,'00:00:00',</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Col</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">) </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">as</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Chk</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">;<BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">load</STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> * </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Inline</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /> </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[<BR /> Col<BR /> 12:10:34<BR /> 10:12:34<BR /> 01:23:45<BR /> -<BR /> 23:12:28<BR /> 11:34:49<BR /> ]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">; </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108483_Capture.PNG" style="height: auto;" /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Regards</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Anand<BR /></SPAN></P></BODY></HTML> Wed, 09 Dec 2015 15:03:20 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/982679#M949663 its_anandrjs 2015-12-09T15:03:20Z Re: Convert Null Values (hh:mm:ss) to 00:00:00 https://community.qlik.com/t5/QlikView/Solved/m-p/982680#M949664 <HTML><HEAD></HEAD><BODY><P>Something like this?</P><P></P><P>IF (ISNULL(mytimefield), MAKETIME(0,0,0), mytimefield) AS mytimefield</P></BODY></HTML> Wed, 09 Dec 2015 15:07:04 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/982680#M949664 roger_stone 2015-12-09T15:07:04Z