Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to convert SGT time to IST time in qlikview application

Hi All,

Dashboard is displaying SGT time. I need to convert it to IST time. Kindly do the needful.

Coding used to capture the refresh time :

timestamp(timestamp#(ReloadTime(),'MM/DD/YYY hh:mm:ss TT'),'DD-MMM-YYYY hh:mm:ss TT')

Tags (1)
1 Reply
Highlighted
Specialist III
Specialist III

Re: How to convert SGT time to IST time in qlikview application

Hi,

In your script you can create new field like some thing below:

Timestamp(ReloadTime()-2.5,'hh:mm:ss TT') as ISTTime