Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sabirashanaaz
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')

1 Reply
vardhancse
Specialist III
Specialist III

Hi,

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

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