Two master calendar date son a single chart

[delbooth]

Hi .

Is it possible to plot two set of data that each has their own master calendar on one line graph, the data is from two tables (databases) that do not have a unique identifier between them.

for example

Quantity collected has a master calendar assigned to it - a month field  Jan - Dec

Quantity dispatched has a separate master calendar assigned to it - a month field Jan-Dec

It seems you cannot plot one of the master calendar times scales as a dimension and use both of the data sets as measures.

Any ideas

Thanks

[ogautier62]

Hi,

in that case use one master calendar (for dimension) and make a new table with :

datecollected   date dispatched   datecalendar   typedate ('dispatched'or 'collected')

01/01/18                                        01/01/18           collected

                       01/01/18                 01/01/18          dispatched

and in the graph expression with <type = {'collected'  or 'dispatch'} to chose on what date you want link

regards

[delbooth]

Thanks Olivier.

I assume you make the new table in Qlik sense and not a new database, apologies if question is simple but I am new to Qlik sense.

If so, how do you create a table in qlik sense to pull the data togther

[ogautier62]

something like this

multipledates:

load datecollected, datecollected as datecalendar,'collected' as typedate resident table1

load datedispatched, datedispatched as datecalendar, 'dispatched' as typedate resident table2

assume that you have a calendar with datecalenday for dates

[delbooth]

Thanks