topic Re: How to add multiple time zones to x-axis of chart? in QlikView

How to add multiple time zones to x-axis of chart?

Anonymous — Tue, 29 Aug 2017 19:15:56 GMT

Need to add IST, GMT and EST formats to show different time zones on x-axis.

9/11/17 Update:

trying to add an input box with the options: IST, EST, and GMT.

Time on the x-axis will then be calculated depending on the selection. To do so, I attempted to add a calculated dimension:

=ConvertToLocalTime(Hour,
if(vTimeZone= 'IST','GMT+09:30',
if(vTimeZone= 'EST','GMT',
if(vTimeZone='GMT','GMT+05:00'))))

Note:

vTimeZone is a Variable

Hour is a field seen in the chart above already in EST.

This expression is not working- any ideas?

Re: How to add multiple time zones to x-axis of chart?

rwunderlich — Tue, 29 Aug 2017 23:46:25 GMT

You can add one more time zone by creating an expression that calculates the hour (relative to EST, your x-axis) and using the "Text on Axis" display option for the Expression.

-Rob

Re: How to add multiple time zones to x-axis of chart?

Anonymous — Tue, 12 Sep 2017 16:19:56 GMT

Correct code:

Note-

found out hour contained both numeric and string values

= ConvertToLocalTime( IF(IsNum(Hour), TIME(Hour),TIME#(Hour,'hh:mm')),

If(vTimeZone = 'IST', 'GMT+09:00',
If(vTimeZone = 'EST', 'GMT+00:00',
If(vTimeZone = 'GMT', 'GMT+05:00',
)))

)