Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
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