Multiple date dimensions on one Combo Chart

[jmccann]

I am attempting to create a combo chart with two sets of data, each with their own date field. I would like the combo chart to display both sets of data on the same timeline; however, the combo chart does not support combining dimensions. Is this possible to achieve using a calculated dimension, or another way of transforming the data?

My data model is relatively complex, so I've distilled down an example:

[Widgets]:
Load *
INLINE [
Project_ID, Widget, Widget_amount, Widget_date
1, A, 19, 20020101
1, B, 34, 20020102
1, C, 51, 20020105
2, A, 15, 20020104
2, B, 13, 20020101
2, C, 52, 20020103
];

[Gadgets]:
Load *
INLINE [
Project_ID, Gadget, Gadget_amount, Gadget_date
1, X, 6, 20020106
1, Y, 3, 20020102
1, Z, 7, 20020105
2, X, 2, 20020104
2, Y, 4, 20020101
2, Z, 5, 20020102
];

Project_ID	Widget	Widget_amount	Widget_date
1	A	19	20020101
1	B	34	20020102
1	C	51	20020105
2	A	15	20020104
2	B	13	20020101
2	C	52	20020103

Project_ID	Gadget	Gadget_amount	Gadget_date
1	X	6	20020106
1	Y	3	20020102
1	Z	7	20020105
2	X	2	20020104
2	Y	4	20020101
2	Z	5	20020102

I can make the individual bar charts (first two images) but I need to display these on the same chart (like in the third image). The tables are linked based on the Project_ID field, which I use to filter the visualizations and to link several other data sources. I feel like there's something basic I'm missing here but this has been throwing me for a loop for a while. Any help would be appreciated!

Gadgets by DateWidgets by Date

Combined (mock-up)

[hic · Accepted solution]

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578