topic Re: Link not getting created between master calendar and main table in QlikView

Link not getting created between master calendar and main table

mugdhaojha — Sat, 16 May 2015 10:54:05 GMT

Hi,

I am trying to develop a dashboard with ticket details and for that I have created a master calendar.

But somehow the master calendar is not getting linked to each incident number in the main table.I have checked the data and there are no records without the Reported date(field on which I have created the master calendar).

I have attached some screenshots of the issue.

Re: Link not getting created between master calendar and main table

Gysbert_Wassenaar — Sat, 16 May 2015 10:57:08 GMT

Make sure that the dates in your fact table and master calendar are dates and not timestamps. You can use the floor function to cut of the time part from timestamps if necessary: date(floor(TicketOpeningDate),'YYYY-MM-DD') as TicketOpeningDate

Re: Link not getting created between master calendar and main table

mugdhaojha — Sat, 16 May 2015 19:01:47 GMT

Thanks alot..That worked!!