Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

Master Calendar for Different Date Columns in different tables

Hello Experts,

I have loaded 6 to 7 sql query tables all of them are having different date columns so for them I want create one master calendar how can we create that calendar and how can we create the relationship for them

Please Help me out from this

stalwar1

Thank you in Advance

Regards,

B V S Sudhakar

3 Replies
sunny_talwar

Check this out

Canonical Date

kfoudhaily
Partner - Creator III
Partner - Creator III

I find this article from @HIC interresting too:

Why You sometimes should Load a Master Table several times

regards,

QlikView Qlik Sense consultant
bvssudhakar
Creator III
Creator III
Author

Hello Guys,

Here i attached sample Excel sheet, In this table 5 to 6 date columns are there

Example: i am creating one bar chart/table for title name wise placements for this i use title name as dimension and =Count({<plcdate = {"*"}>}CandidateID) as expression

and now i have to create one list box for plcdate column

And now, again i am creating one bar chart/table for title name wise Declines for this i use title name as dimension and =Count({<Declinedate = {"*"}>}CandidateID) as expression

for this i have to create one more list box for Decline date column


Again i am creating one bar chart/table for title name wise Offered Candidates for this i use title name as dimension and =Count({<Offerdate = {"*"}>}CandidateID) as expression

for this i have to create one more list box for offer date column


But user is not accepting these many list boxes separately. they want only two list boxes year and month or hierarchy calendar list box that will apply to all date columns


This is the sample data and one of the major requirement from client

Massimo Grossi dushan chathuranga.



Please Help me out from this guys


Thank you in advance