Time zone plotted on a continuous chart

Wed, 02 Aug 2017 09:58:47 GMT

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

topic Time zone plotted on a continuous chart in QlikView

Time zone plotted on a continuous chart