Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
abdulaziz
Contributor III
Contributor III

How to change today() timezone in qliksense saas ?

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 

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
abdulaziz
Contributor III
Contributor III
Author

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

View solution in original post

2 Replies
SBN
Contributor III
Contributor III

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.

abdulaziz
Contributor III
Contributor III
Author

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