topic Re: Mapping question in QlikView

Mapping question

raju_salmon — Mon, 14 Dec 2015 07:44:41 GMT

Hi,

I need a suggestion on below scenario.

I have FACT Table with Call information, we have different vendors.

The requirement is to see the calls answered on particular day of all vendors.

Here issue is vendors are sitting at different locations, and i am unable to map the time zones with columns available.

Please find the attached files.

Thanks for your help for mapping here.

Anonymous — Mon, 14 Dec 2015 07:56:18 GMT

What is the link b/w CallInfo & Calender QVD?

Is it Date??

tamilarasu — Mon, 14 Dec 2015 08:10:31 GMT

Hi Raju,

Check the below attachment.

I would suggest you to use master calendar.

raju_salmon — Mon, 14 Dec 2015 08:34:45 GMT

Hi,

Here i need to map the information available in 'VendorLocalTime' field with Columns GMT, IST, JST, AST etc.

raju_salmon — Mon, 14 Dec 2015 08:36:05 GMT

Hi,

We need to map columns GMT, IST, JST, AST with information available in 'VendorLocalTime' column.

Anonymous — Mon, 14 Dec 2015 08:42:49 GMT

See the attachment...

Use Cross table for Call Info....

Then create master calender based on date of Call info...

Hope this will help!!

Anonymous — Mon, 14 Dec 2015 08:43:43 GMT

Check my attachment and create master calender on date field of Call Info table