Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Link not getting created between master calendar and main table

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.

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Contributor II
Contributor II

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

Thanks alot..That worked!!