topic Re: Alternatives to ConvertToTimezone in App Development

Alternatives to ConvertToTimezone

pedrohenriqueperna — Thu, 23 Nov 2023 01:08:40 GMT

Hi!

I have this dashboard that is used to fire some reports by e-mail and it comes a time of the day that Qlik's server doesn't match my country's time and I get wrong outputs.

I got around it using ConvertToLocalTime(UTC(), 'UTC-03:00') in my expressions, but it seems this function is constantly updated and it glitches my app, specially the scrolling bars.

I'm actually surprised we can't set out timezones in the management console and I assume it's something on the roadmap. Meanwhile, is there a workaround that won't use that much processing?

If I add the value to a variable on script level and then calculate the variable inside my expressions, will it result in the same behavior as using them directly?

Re: Alternatives to ConvertToTimezone

TcnCunha_M — Thu, 23 Nov 2023 08:17:24 GMT

what I could suggest is to create a table on that data model, with the timezones you need then use that particular field and use in your report base by with country you are sending.

Re: Alternatives to ConvertToTimezone

marcus_sommer — Thu, 23 Nov 2023 10:24:08 GMT

Maybe now() is an alternatively for utc() as it provides a time_mode paramter:

now - script and chart function | Qlik Cloud Help

Re: Alternatives to ConvertToTimezone

pedrohenriqueperna — Thu, 23 Nov 2023 14:06:55 GMT

Hi, it seems to be a good idea, will sure have a try. Thanks for replying.

Re: Alternatives to ConvertToTimezone

pedrohenriqueperna — Thu, 23 Nov 2023 14:09:27 GMT

Hi, Marcus

Thanks for the reply.

Wouldn't Now() have the same behavior of being constantly recalculated?

Re: Alternatives to ConvertToTimezone

marcus_sommer — Thu, 23 Nov 2023 14:13:46 GMT

Not by choosing 0 or 2 as timer_mode:

Argument	Description
timer_mode	Can have the following values: 0 (time at last finished data load) 1 (time at function call) 2 (time when the app was opened)

Argument

Description

timer_mode

Can have the following values:

0 (time at last finished data load)
1 (time at function call)
2 (time when the app was opened)

Re: Alternatives to ConvertToTimezone

pedrohenriqueperna — Thu, 23 Nov 2023 14:55:25 GMT

This will definitely work!! Thank you very much @marcus_sommer.