Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vardhancse
Specialist III
Specialist III

IST & SGt Time to USA & UK

Hi,

I have a requirement to change timezone based on a button click for different countries like SGT, MN, IST, USA & UK.

Except for USA & UK, done using below mentioned script:

Timestamp(StartHour + 2.5) for IST to Manila

Timestamp(StartHour + 4.5) for IST to Aus


However facing issue with USA & UK by using below condition


Timestamp(StartHour - 9.5) for IST to USA

Timestamp(StartHour - 4.5) for IST to UK


Result is going in negative format, ideally its wrong


In front end / presentation trying to create a chart to show the staff roster and selection based on button.


Can any one let me know the option to convert the time format


2 Replies
yoganantha321
Creator II
Creator II

What does the StartHour means
whether 00:00 hrs of today?

MarcoWedel

please post some sample values and your expected result.