topic Re: Convert time 'hh' into number in QlikView

Convert time 'hh' into number

geogou1973 — Sun, 05 Mar 2017 18:50:08 GMT

Hello,

Have anyone an idea how can i convert the following expression that i have it in an variable into number ?

=time(time(now() - 1/24,'hh:mm'),'hh')

this variable returns only the current system hour 'hh' minus 1

I want this because i have this variable in a straight chart and when the user tries to scroll down automatically the cursor returns to the top because the server calculate the time every second and i want to avoid this.

Thank you in advance.

Re: Convert time 'hh' into number

Peter_Cammaert — Sun, 05 Mar 2017 18:57:12 GMT

Avoid using the now() function. It will repeatedly trigger frequent evaluations.

Did you try using the LocalTime() function?

Re: Convert time 'hh' into number

geogou1973 — Sun, 05 Mar 2017 19:08:09 GMT

Hello Peter,

I have the same problem like before.

Re: Convert time 'hh' into number

Peter_Cammaert — Sun, 05 Mar 2017 19:18:19 GMT

Is it really necessary to have an updated time value? Can't you set it in your load script?

Re: Convert time 'hh' into number

Peter_Cammaert — Sun, 05 Mar 2017 19:21:07 GMT

what about :

=time(time(now( 2 ) - 1/24,'hh:mm'),'hh')

Re: Convert time 'hh' into number

geogou1973 — Sun, 05 Mar 2017 19:25:51 GMT

It works, what is doing the number 2 ?

Re: Convert time 'hh' into number

Peter_Cammaert — Sun, 05 Mar 2017 19:32:20 GMT

IMHO it's always a good idea to check out what you get for free (or Qlik may decide to stop maintaining the docs due to lack of an audience )

now ‒ QlikView

I should add that the QV Desktop Help article is a bit better than the on-line version. The Desktop Help article at least warns you that using timermode = 1 (the default) may have unwanted consequences.