Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
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