Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Linking Time Zone

Hi,

Since i am new to qlikview, can you please help me on this.

I have a base table with ID and 6 different time zone date and time. Means each ID have 6 extra columns with date (IST,PST,CHST etc) and also 6 other columns available with Unique number. IST-1, PST-2.

All i have to do is, i need to display Time zone list box for user to select relevant time zone.

Do i need to create a inline table with 6 times zones and how can i link them with based table? Can i get your help please.

Thanks,

venkatesh

7 Replies
Gysbert_Wassenaar

Can you post a small qlikview document that makes clear what the problem is?


talk is cheap, supply exceeds demand
Not applicable
Author

Hello Gysbert, !

Sorry for the confusion. Please find attachments for more clarity.

Here i have total callsanswered information in sample qvw file, I need to show a list box with time zones. So based on time zone selection and date selection i need to shown total calls answered result. Example one call answered on 19th Nov in IST time zone which comes under 18th Nov PST.

Thanks.

Gysbert_Wassenaar

Sorry, I can't make sense of your example data. I have no idea what's what. Can you explain in it more detail with a couple of examples?


talk is cheap, supply exceeds demand
Mark_Little
Luminary
Luminary

Hi,

You need to load each part at a time and concatenate the tables'

TABLE

LOAD

          'UID'   as TimeZone,

          SessionID,

          CreateDateUID          AS CreateDate,

          StartDateUID             AS StartDate,

....

FROM...'Your source'

Concatenate (TABLE)

Load

     'UIDPST'                     AS Timzone,

     CreateDateUIDPST     as CreateDate,

..

Carry on with this logic. Then you use the TimeZone Field to change the selections

Mark

Not applicable
Author

Hi Gysbert,

If i am wrong earlier, below are details with more clarity.

1. I have a table with session ID, Date (CreateDateUID) and TotalCallsanswered. If i want to see Daily TotalCallsanswered, i can take Sum(TotalCallsanswered) with Date (CreateDateUID) dimension. So i can see daily wise data here.

2. My requirement is simple. In the same above table i have different dates based on respective timezone. Ex: For one sessionID date is available 22ndNov for IST whereas 21stNov PST.

3. My Requirement is to provide Time Zone list box to select accurate figure based on their TimeZone. For PST users, the above record should display for 21st date only.

Hope this would help me.

Thanks for patience.

Not applicable
Author

Thanks for the reply Mark. Is my understanding correct? Please see the attachment.

Can you correct it if i am wrong?

veeranj
Creator II
Creator II

Hi ,

Did you got any solution for this scenario ?

as i am also having the same requirement .

Thanks,

Anjee