How to change time zone in QlikSense app to match values with Datasource?

[Anonymous]

Hello,

I am currently making an app that draws its data from Saleforce. I noticed that the tables I am producing do not match in values with what is showing in my Salesforce data. This is because the values of my datasource is including some values from the previous day. I suspect that this is because the time zone for my tables in QlikSense is NOT the same timezone for what is showing in Salesforce. Here are some screenshots to show what I am talking about:

As you can see, the last four patients from 12/3/2017 were added to my data from 12/4/2017 in my QlikSense table, instead of being in the 12/3/2017 date in the QlikSense table to match my datasource.

I tried to fix this mismatch by adding 'yyyy-MM-dd', 'Etc/GMT+4' to the "Created Date" field, but that didnt work. Is there anything I can do to fix this? THANK YOU in advance for your assistance!!

[OmarBenSalem]

try in the script to change the created date field as follow:

date( date#("Created Date", 'DD/M/YYYY')) as "Created Date",

[Anonymous]

Thank you for your reply! I tried you suggestion, but the issue still persists. Is there anything else I can try? Thanks again!

[teiswamsler]

hi Muhammed

Try converting the timestamp using ConvertToLocalTime()

otherwise

add or subtrack hours to your  "Timestamp" + 1/24 (1hour)..... + 2/24 (2 hours)....

I hope i will get you in the right dirrection

/Teis

[Anonymous]

Thank you for your help! I was wondering how I should use the Convertlocaltime() function in this case?

The name of the field is =[CreatedDate.autoCalendar.Date] , and the time zone is GMT +4. Thanks again!!