topic Re: Master Calendar for Different Date Columns in different tables in QlikView

Master Calendar for Different Date Columns in different tables

bvssudhakar — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Master Calendar for Different Date Columns in different tables

sunny_talwar — Mon, 06 Aug 2018 14:53:44 GMT

Check this out

Canonical Date

Re: Master Calendar for Different Date Columns in different tables

kfoudhaily — Mon, 06 Aug 2018 15:03:51 GMT

I find this article from @HIC interresting too:

Why You sometimes should Load a Master Table several times

regards,

Re: Master Calendar for Different Date Columns in different tables

bvssudhakar — Tue, 07 Aug 2018 07:50:31 GMT

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