topic Re: timestamp in QlikView https://community.qlik.com/t5/QlikView/timestamp/m-p/609977#M225125 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-4876">Qlikview 10 SR4 Reference Manual</A></P><P></P><P>pages 447ff</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 23 Mar 2014 21:21:00 GMT MarcoWedel 2014-03-23T21:21:00Z timestamp https://community.qlik.com/t5/QlikView/timestamp/m-p/609974#M225122 <HTML><HEAD></HEAD><BODY><P>timestamp handeling in Qlikview</P></BODY></HTML> Sun, 23 Mar 2014 08:01:14 GMT https://community.qlik.com/t5/QlikView/timestamp/m-p/609974#M225122 agni_gold 2014-03-23T08:01:14Z Re: Load data from QVD based on timestamp condition. https://community.qlik.com/t5/QlikView/timestamp/m-p/609975#M225123 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">use <STRONG>time</STRONG> function inplace</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">temp:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; Timestamp(CBATIME) as cba</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FROM</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><E></E></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(qvd);</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">temp2:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">load</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">cba</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Resident temp where Time(cba, 'HH:MM:SS TT')='12:00:00 AM';</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">hope this helps</P></BODY></HTML> Sun, 23 Mar 2014 08:05:19 GMT https://community.qlik.com/t5/QlikView/timestamp/m-p/609975#M225123 SunilChauhan 2014-03-23T08:05:19Z Re: Load data from QVD based on timestamp condition. https://community.qlik.com/t5/QlikView/timestamp/m-p/609976#M225124 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Try like</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">temp:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; Timestamp(CBATIME,'HH:MM:SS TT' ) as cba</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FROM</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><E></E></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(qvd);</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">temp2:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">load</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">cba</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Resident temp where cba ='12:00:00 AM';</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hope this helps</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks &amp; Regards</P></BODY></HTML> Sun, 23 Mar 2014 08:51:43 GMT https://community.qlik.com/t5/QlikView/timestamp/m-p/609976#M225124 its_anandrjs 2014-03-23T08:51:43Z Re: timestamp https://community.qlik.com/t5/QlikView/timestamp/m-p/609977#M225125 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-4876">Qlikview 10 SR4 Reference Manual</A></P><P></P><P>pages 447ff</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 23 Mar 2014 21:21:00 GMT https://community.qlik.com/t5/QlikView/timestamp/m-p/609977#M225125 MarcoWedel 2014-03-23T21:21:00Z