topic Re: Convert time as per user selection in QlikView

Convert time as per user selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Convert time as per user selection

vishsaggi — Thu, 04 May 2017 02:03:29 GMT

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

Re: Convert time as per user selection

Anil_Babu_Samineni — Thu, 04 May 2017 02:05:43 GMT

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

Re: Convert time as per user selection

shiveshsingh — Thu, 04 May 2017 02:06:03 GMT

try using below function

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

Re: Convert time as per user selection

rwunderlich — Thu, 04 May 2017 03:35:56 GMT

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

Re: Convert time as per user selection

Anonymous — Thu, 04 May 2017 05:54:02 GMT

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.

Re: Convert time as per user selection

Anonymous — Thu, 04 May 2017 06:44:06 GMT

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.