Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
harish_meda
Contributor II
Contributor II

I have 5 tables like below and need to create a master calendar.

 
 

I have 5 tables like below and need to create a master calendar.

Knowledge:
KnowledgeIDKey,
"Knowledge.Create Date/Time"


KnowledgeFeedback:
"KnowledgeFeedback. Create Date/Time"
KnowledgeIDKey,
ArticleUserKey


KnowledgeUSe:
"KnowledgeUse.Create Date/Time"
ArticleUserKey

KnowledgeTask:
"KnowledgeTask.Create Date/Time"
KnowledgeIDKey,
TicketKey


Ticket:
TicketKey,
"Ticket.Create Date/Time"

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You will want to create a link table to link all your tables to a single calendar. Take a look at this tutorial for details. 

Qlikview Cookbook: Tutorial - Using Common Date Dimensions https://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

-Rob