Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Time zone plotted on a continuous chart

Hello,

I have built a chart showing the production of a machine from midnight (0:00) to midnight (23:59) splitting in 5 minutes intervals.

All good until I had to change the timestamps to a different timezone (from UTC to CEST) which I did using ConvertToLocalTime function.

But this changed the way the chart plots the continuous axis time slots (instead of 0:00 - 23:59 is shifting the chart with the 2 hours difference between the timezones).

I tried to solve this by forcing the start to zero but this did not help... see the attached picture with the 3 representations of the same data, chart title explaining the situation.

How i need to be displayed is as in the UTC chart but on the CEST time (completely ignoring the alteration to the timezone I did). Is this possible? Maybe if i change the timezone in the LOAD SCRIPT instead of at expression level? (would be more efficient anyway)

best,

Alex

0 Replies