topic Re: Facts table not getting linked with Master Calendar in QlikView

Facts table not getting linked with Master Calendar

Anonymous — Tue, 13 Sep 2016 12:06:14 GMT

I need to plot the number of tickets resolved per month

I have added the master calendar and linked to the resolve dates but the dates are not gettting linked to show the tickets.

Can anybody please help? is this anything to do with timestamp issue?.

Re: Facts table not getting linked with Master Calendar

sunny_talwar — Tue, 13 Sep 2016 12:15:44 GMT

Try the attached. New Script:

TR_Dump:

LOAD [Date Raised],

[TR #],

Date(Floor([Resolved Date])) as [Resolved Date]

FROM

[Test Data.xlsx]

(ooxml, embedded labels, table is [TR Dump today]);

Re: Facts table not getting linked with Master Calendar

its_anandrjs — Tue, 13 Sep 2016 12:38:28 GMT

In your excel file date is not on proper order please check after correction you get right data.

Regards,

Anand

Re: Facts table not getting linked with Master Calendar

Anonymous — Tue, 13 Sep 2016 14:28:00 GMT

Thanks..This has worked..Can you please help me understand what floor has done in this expression? i tried using only date function and it didn't work

Re: Facts table not getting linked with Master Calendar

Anonymous — Tue, 13 Sep 2016 14:29:38 GMT

Also will you be able to help me with another query?

I need to create another master calendar to link the Date Raised field from the facts table. If i use the same master calendar script will it not disturb the data as Month is common in both the master calendar scripts?

Re: Facts table not getting linked with Master Calendar

sunny_talwar — Tue, 13 Sep 2016 19:27:22 GMT

Floor removes the time component from a date and time field. I think the connection between master calendar and your fact table broke because of time in the [Resolved Date] field. It would be good to read about dates here:

Get the Dates Right

Why don’t my dates work?

Re: Facts table not getting linked with Master Calendar

sunny_talwar — Tue, 13 Sep 2016 19:28:31 GMT

Read here:

Canonical Date

Handling Multiple Calendars.qvw

Linking to two or more dates