New to Qlikview

[#1]

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

[Joaquin_Lazaro]

Hi King K:

See LocalTime() function al QlikView help.

Joaquín

[Joaquin_Lazaro]

Hi again:

See also at QlikView Help

UTC()

GMT()

TimeZone()

Joaquín

[sujeetsingh]

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?

[sujeetsingh]

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

[Anonymous]

Hi,

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

UTC()

GMT()

TimeZone()

Warm regards,

Venkata Sreekanth

[Joaquin_Lazaro]

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

[sujeetsingh]

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.

[Joaquin_Lazaro]

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

[MarcoWedel]

store Timestamps as UTC and display them using

ConvertToLocalTime(Timestamp)