Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
harish_meda
Contributor II
Contributor II

how to create master calendar for multiple table for different dates with keys

Hi All,

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

Knowledge:
KnowledgeIDKey,
"Knowledge.Create Date/Time",
KnowledgeIDKey&"Knowledge.Create Date/Time" as Key,

KnowledgeFeedback:
"KnowledgeFeedback. Create Date/Time",
KnowledgeIDKey,
ArticleUserKey,
KnowledgeIDKey&"Knowledge.Create Date/Time" as Key,
ArticleUserKey&"KnowledgeFeedback.Create Date/Time" as Key2,


KnowledgeUSe:
"KnowledgeUse.Create Date/Time",
ArticleUserKey,
ArticleUserKey&"KnowledgeFeedback.Create Date/Time" as Key2

KnowledgeTask:
"KnowledgeTask.Create Date/Time",
KnowledgeIDKey,
TicketKey,
KnowledgeIDKey&"KnowledgeTask.Create Date/Time" as Key,
TicketKey&"KnowledgeTask.Create Date/Time" as Key3,

Ticket:
TicketKey,
"Ticket.Create Date/Time",
TicketKey&"KnowledgeTask.Create Date/Time" as Key3,

 

1 Reply
harish_meda
Contributor II
Contributor II
Author

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"