Discussion Board for collaboration related to QlikView App Development.
Need to add IST, GMT and EST formats to show different time zones on x-axis.
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'))))
vTimeZone is a Variable
Hour is a field seen in the chart above already in EST.
This expression is not working- any ideas?
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', ))) )
View solution in original post
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.