Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

We value your feedback – take our 5-minute QlikView modernization survey
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How to create an integrated / combined calendar over two fact tables with several date fields?

Dear all,

given is the following data model:

I created several calendar dimensions. However, users would like to see the data over one combined date Dimension with all possible date values and also those Dates where there are no values in any record. For example, they would like to see values over the two fields "ZVAE.Angelegt am_ERDAT" and "ZS620.Buchhaltungs-Datum_VALDT".

I think a link table and / or generic keys might be a solution, but I did not succeed. Can you please offer advice? Please find attached a .qvw-file.

Thank you very much in advance.

1 Reply
MVP & Luminary
MVP & Luminary

I think this will be helpful: Canonical Date.

- Marcus