topic Re: Output of Hour() function in QlikView

Output of Hour() function

Anonymous — Tue, 31 Jan 2017 17:46:18 GMT

Hi,

why am i getting the '0' value in vHour variable using Today() function?

Re: Output of Hour() function

Nicole-Smith — Tue, 31 Jan 2017 18:01:57 GMT

You need to use dollar sign expansion:

LET vToday = Today();

LET vHour = Hour($(vToday));

The vHour will still be equal to 0 because Today() uses 12:00 AM for its timestamp. If you want the current timestamp, you'll want to use now():

LET vToday = Now();

LET vHour = Hour($(vToday));

Re: Output of Hour() function

Anonymous — Tue, 31 Jan 2017 18:09:34 GMT

Hi Nicole,

Thank you for the quick reply but can you please specify why should i use Dollar sign expansion and I cannot see the hour value based on the day like Today?

Re: Output of Hour() function

sunny_talwar — Tue, 31 Jan 2017 18:10:15 GMT

Or just

LET vHour = Hour(Now())Today();

Re: Output of Hour() function

Anonymous — Tue, 31 Jan 2017 18:23:03 GMT

Hi Sunny,

Your answer is still giving me 0 in vHour variable but in vToday variable it is giving me date and time.

Re: Output of Hour() function

Nicole-Smith — Tue, 31 Jan 2017 18:49:01 GMT

In the load script, you need to use dollar sign expansion to get the value in a variable.

As for the hour, Today() will return '2017-01-31 00:00:00.000' while Now() will return the timestamp of when it is called (i.e. '2017-01-31 10:49:03.386').

Re: Output of Hour() function

swuehl — Tue, 31 Jan 2017 19:10:40 GMT

I don't think you need dollar sign expansion here (you would need it in a LOAD statement, not necessarily in control statements or LET variable assignment).

Let vToday = Now();

Let Hour = Hour(vToday);

vToday	31.01.2017 20:09:10
vHour	20

Re: Output of Hour() function

sunny_talwar — Tue, 31 Jan 2017 19:12:28 GMT

Let vHour = Hour(Now()); is giving 0? Really?

Re: Output of Hour() function

Nicole-Smith — Tue, 31 Jan 2017 19:27:10 GMT

Good to know swuehl‌. Thanks for the correction!

Re: Output of Hour() function

Anonymous — Wed, 01 Feb 2017 04:42:30 GMT

Hi stefan,

Thank You so much for the information and your answer worked for me.

Re: Output of Hour() function

Anonymous — Wed, 01 Feb 2017 04:44:22 GMT

Earlier it was giving me 0 but after u made the correction, it worked.

Thank you.