Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts!
Can anyone please help understand how to change today() timezone in qliksense saas ?
I already update the timezone in Profile but after 12AM , the time return by today() is GTM only and need to wait 3 hours up the new day come up
I need to change it to GTM+3
I try this script
LET Today =date(Num(ConvertToLocalTime(Today(),'Riyadh')));
LET vToday =date(num(ConvertToLocalTime(UTC(),'Riyadh')));
LET reloadtime =ConvertToLocalTime(reloadtime(),'Riyadh');
only vToday is change but I use today() to get all the data and calendars
Thanks
Hi
Thanks for your reply. i found the solution by updating vToday_date
LET vToday_date = Date(ConvertToLocalTime(UTC(), 'GMT+03:00'));
and when i load some date i used
Where (DATE = '$(vToday_date)' )
let point is in the calendar
LET vToday = Num('$(vToday_date)');
Thanks for your reply
Hi there,
Maybe you can change the "Today()" function in your load script for the "LocalTime()" function?
localtime - script and chart function | Qlik Sense on Windows Help
Kind regards.
Hi
Thanks for your reply. i found the solution by updating vToday_date
LET vToday_date = Date(ConvertToLocalTime(UTC(), 'GMT+03:00'));
and when i load some date i used
Where (DATE = '$(vToday_date)' )
let point is in the calendar
LET vToday = Num('$(vToday_date)');
Thanks for your reply