topic Re: Common Calendar for Date field in different unrelated tables. in Connectivity & Data Prep

Common Calendar for Date field in different unrelated tables.

irshadvaza — Tue, 13 Feb 2018 09:13:59 GMT

I would like to ask you a common calendar solution for date filed in different unrelated tables. I walked through Rob Wunderlish solution whcih is related related table with common filed e.g OrderId but I am looking for a solution of unrelated tables.

Re: Common Calendar for Date field in different unrelated tables.

swuehl — Tue, 13 Feb 2018 19:02:12 GMT

What do you mean with 'unrelated' tables? They are not connected in your data model, i.e. there are multiple data islands?

Re: Common Calendar for Date field in different unrelated tables.

irshadvaza — Wed, 14 Feb 2018 04:15:35 GMT

Hi Stefan,

Thank you very much for your response.

Yes you are right, unrelated means there is not any relation (no common field) between two or more tables which contain date filed.

e.g.

There are three tables contain date field (Issue Date) How can I use the common calendar to filter the data or I have to use the separate calendar ?

Table Name
Annual License	ID
	license Numer
	Issue Date

Trip Permit	PermitID
	PermitNumber
	IssueDate

Password Lincese	PLID
	PasswordNumber
	IssueDate

Thanks and regards,

Irshad

Re: Common Calendar for Date field in different unrelated tables.

petter — Wed, 14 Feb 2018 16:22:02 GMT

If you have three tables with the field names as you listed they will be related by the field IssueDate. Qlik Sense does association (relationships) by name. However if you rename or qualify these IssueDate fields in the load script they will be unassociated (unrelated).

Could you share a screenshot of your Data Model please - then we can assist you better?

The information you shared with us seems to be a theoretical data model - something you haven't yet brought into or materialized in Qlik Sense - right?

Re: Common Calendar for Date field in different unrelated tables.

irshadvaza — Sun, 18 Feb 2018 04:20:13 GMT

Dear Petter,

Thank you very much, let try to use IssueDate field which is available in all unrelated table and I will share the data model screenshot if I have any issue.

Thanks and regards,

Irshad.

Re: Common Calendar for Date field in different unrelated tables.

qazmaster — Mon, 11 Mar 2019 19:00:17 GMT

Hi! I have same question as yours. How did u fix this issue?