topic Re: Display Time as per "Region" Filter in QlikView

Display Time as per "Region" Filter

Anonymous — Tue, 18 Apr 2017 17:52:00 GMT

Hi All,

I have created a line chart for my data - Email Responses by time of the day.

I have a filter "Contact Theater" which has values "APAC", "EMEA", "NA". The below chart displays data when I select "NA" as a filter. The time bucket information is in EST time zone.

I need to display the Time bucket data when I select a Region -> APAC or EMEA . My current issue is when I select APAC Region. It displays the time is GMT. If you see the below chart the email responses are highest at 10:00 PM-11:00 PM and also at 1:00 AM - 02:00 AM. I am guessing the time zone isn't changing when I select the APAC region. Can you please help?

Re: Display Time as per "Region" Filter

Anil_Babu_Samineni — Tue, 18 Apr 2017 17:56:39 GMT

Can you have a look this

Time Bucket for Hour

Re: Display Time as per "Region" Filter

Anonymous — Tue, 18 Apr 2017 18:17:49 GMT

Thank you Anil for Sharing the Link. However I have already created the TimeBucket field in my load script. I just need to know when I select a different region I need to see the time data of that selected Region. In my second chart where I select the APAC region it gives me the data at odd times like 1:00 AM - 02:00 AM or 10:00 PM -11:00 PM.

Re: Display Time as per "Region" Filter

MarcoWedel — Tue, 18 Apr 2017 23:27:28 GMT

please post a sample application to demonstrate this issue

Re: Display Time as per "Region" Filter

Anil_Babu_Samineni — Wed, 19 Apr 2017 02:03:49 GMT

Seems you are working QS. Would you shre sample qvf file

Re: Display Time as per "Region" Filter

Anonymous — Thu, 04 May 2017 06:40:49 GMT

Hi Marco,

Attached is sample app. 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.