topic Re: Help with date format in QV12 Loadbalancer file in QlikView

Help with date format in QV12 Loadbalancer file

ebalmelli — Sat, 16 Nov 2024 19:31:27 GMT

Want to load the records from the QV12 LoadBalancer_YYYYMMDD.txt file. An example of what is in the file is shown here.

20191202T000003.608-0500 Information LoadMeasurer: The system is currently overloaded. Memory value: 2.8838482560129 CPU value: 100
20191202T000103.715-0500 Information LoadMeasurer: The system is not overloaded anymore.

Tried manually using ConvertToLocalTime('20191202T000003.608-0500') as well as =timestamp('20191202T000003.608-0500'). Also tried removing the -500. Not having any luck.

Anyone else figured out how to convert this format into a Date? Month? h:mm:ss?

thanks,

Re: Help with date format in QV12 Loadbalancer file

atoz1158 — Wed, 04 Dec 2019 14:57:33 GMT

Try the following which for me on the timestamp field out of QV session files.

date([yourTSField],'DD/MM/YYYY hh:mm:ss')

Regards

Adrian

Re: Help with date format in QV12 Loadbalancer file

ebalmelli — Mon, 09 Dec 2019 21:06:51 GMT

Thanks Adrian, unfortunately it didn't work.

=date('20191202T000003.608-0500','DD/MM/YYYY hh:mm:ss')

Re: Help with date format in QV12 Loadbalancer file

atoz1158 — Tue, 10 Dec 2019 11:42:02 GMT

Did it not work at all or did it not return what you expected?

It can be a little confusing thinking that the -0500 should be reducing the time but of course what it means is that the local time is 5 hours behind UTC (GMT) and therefore converted to UTC it will add on 5 hours.

Regards

Adrian

Re: Help with date format in QV12 Loadbalancer file

ebalmelli — Tue, 10 Dec 2019 13:28:26 GMT

Does not work at all.

If you add a text box to a QlikView report and add the following

=date('20191202T000003.608-0500','DD/MM/YYYY hh:mm:ss')

what do you see?

Re: Help with date format in QV12 Loadbalancer file

atoz1158 — Tue, 10 Dec 2019 14:46:48 GMT

This is what I get

Regards

Adrian

Re: Help with date format in QV12 Loadbalancer file

ebalmelli — Tue, 10 Dec 2019 18:02:13 GMT

Thanks Adrian!

From the research I did, it appears that the timestamp and the date/time functions in QV12 are different than the same functions in QV12. For example the Timestamp() function in QV12 can interpret different date formats than the same function in QV11.

I was using QV11.2 Desktop to look at the Loadbalancer file from our QV12 Server. The problem is looking at a QV12 logfile with the new timestamp format in QV11 desktop doesn't work. However, looking at a QV12 logfile with the new timestamp format in QV12 Desktop works as expected.

Thanks again for helping out!