topic Re: New to Qlikview in QlikView

New to Qlikview

Tue, 13 May 2014 08:57:54 GMT

Hello all,

I am searching for a way to handle local time zone conversions in Qlikview architecture.

Let there be a server in IST timeZone. Now a user access it from PST TimeZone.

Now the user should see the time fields in PST. How to extract timeZone at User side?

We have functions so do it at server side but how to hadle it at user side.

Any macro to extract timezone from web browser?

THANKS

Re: New to Qlikview

Joaquin_Lazaro — Tue, 13 May 2014 09:21:55 GMT

Hi King K:

See LocalTime() function al QlikView help.

Joaquín

Re: New to Qlikview

Joaquin_Lazaro — Tue, 13 May 2014 09:23:37 GMT

Hi again:

Re: New to Qlikview

sujeetsingh — Tue, 13 May 2014 09:24:59 GMT

One can try some settings from server but yes this seems a valid issue and i am Eager to know the solution.Arthur Lee@ samuel Kaushik Solanki Steven Petersen swuehl, John, Miguel, Rob, Kaushik, Erich, Karl, Michael, Oleg

I have invited these experts of Qlik to help out.

Is this a Qlikview bug,limitation?

Re: New to Qlikview

sujeetsingh — Tue, 13 May 2014 09:27:29 GMT

Guys it is not the issue of just handling the Time Zone conversion.

It is the one with the variations of users accessing the server .

It can be that one is accessing it through web from LONDON and the same file is accessed from web from RUSSIA.

It is not easy one

Re: New to Qlikview

Anonymous — Tue, 13 May 2014 09:47:42 GMT

Hi,

you can get help by using following functions available in qlikview they are

UTC()

GMT()

TimeZone()

Warm regards,

Venkata Sreekanth

Re: New to Qlikview

Joaquin_Lazaro — Tue, 13 May 2014 09:52:08 GMT

Hi:

In script you must load the time field with the time zone and in charts use a conversion as you should do with amounts and currency.

Joaquín

Re: New to Qlikview

sujeetsingh — Tue, 13 May 2014 09:59:46 GMT

Lazaro,

Ok let there be a File on server and Publisher distribute it.

Now by default you have taken PST as time zone .

Now someone access it from EST the same file then it should be according to EST .

So the time zone of user may vary.

Now the question is how you are going to derive the time zone of the user .

And then how you are going to handle it in dashboard.

Re: New to Qlikview

Joaquin_Lazaro — Tue, 13 May 2014 10:29:55 GMT

Hi:

I can write the concept, but i don't have enought time to create a full app.

1) The fact table needs two fields Time + TimeZone

2) A dimension table for the User: User + UserTimeZone

3) A conversion table: TimeZone + UserTimeZone + Differential. Differential range values from +12 (Fiyi) to -12 (West Alaska)

Be carefull with summer/winter times, and with date changes at midnight.

The expression on charts have to show Time + Differential.

Joaquín

Re: New to Qlikview

MarcoWedel — Tue, 13 May 2014 10:50:27 GMT

store Timestamps as UTC and display them using

ConvertToLocalTime(Timestamp)

Re: New to Qlikview

sujeetsingh — Tue, 13 May 2014 11:51:36 GMT

How to set Timestamp in UTC

Re: New to Qlikview

Anonymous — Tue, 13 May 2014 11:56:01 GMT

=ConvertToLocalTime(UTC(),'Kolkata')