Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

bvssudhakar
Contributor

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
MVP
MVP

Re: Master Calendar for Different Date Columns in different tables

Check this out

Canonical Date

Highlighted
kfoudhaily
Contributor III

Re: Master Calendar for Different Date Columns in different tables

I find this article from @HIC interresting too:

Why You sometimes should Load a Master Table several times

regards,

bvssudhakar
Contributor

Re: Master Calendar for Different Date Columns in different tables

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