Multiple date dimensions on one Combo Chart

jmccann — Tue, 15 Mar 2022 23:26:32 GMT

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)

Re: Multiple date dimensions on one Combo Chart

hic — Wed, 16 Mar 2022 07:44:57 GMT

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

topic Multiple date dimensions on one Combo Chart in App Development

Multiple date dimensions on one Combo Chart

Re: Multiple date dimensions on one Combo Chart