Convert time as per user selection

[Anonymous]

Hi All,

I have a region field and a timestamp field in a database. All the timestamp is been recorded in Easter Time Zone (EST). I would like to display the data as per the user selection of a region for eg: if a user selected APAC region he should get the data for the APAC and similarly for EMEA.

[vishsaggi]

Can you elaborate with some sample data and your expected output to be?

[Anil_Babu_Samineni]

I am sure, There is no such functionality in Qlikview. I heard there is some option in Spotfire and R-Integration. So in qlikview you need to maintain all dates for Region

[shiveshsingh]

Hi

try using below function

ConvertToLocalTime(timestamp [, place [, ignore_dst=false]])

[rwunderlich · Accepted solution]

You could load a table of hour offsets from EST for the various regions like this:

Offsets:

LOAD Region, num(Interval#(Offset,'h'))  as OffsetINLINE [

Region, Offset

EMEA, 4

APAC, 8

];

Make the user select a single Region using "Always one selected" property on the listbox.

And then when you display the timestamp field in your app chart dimension:

=TimeStamp(TransactionTime + Offset)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Anonymous]

Hi,

I have to calculate the email open rates based on time of the day. The current data has time in GMT.

In the above chart you will see that open rates are highest for time 10:00 AM - 11: AM. This is the data for Americas.

When a user selects the APAC region.  I get the below data with open rates at 10:00 PM - 11:00 PM.

I am looking the above chart to show the data in APAC time zone. Hope you understood.

[Anonymous]

Hi Rob,

Attached is a sample file. What I am looking for is the data should change on user selection of a region filter.

Eg: If the user selects APAC region the chart should change the data as per APAC time. What I am looking for is when Email Open rates are highest.