Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

delbooth
New Contributor II

Two master calendar date son a single chart

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

4 Replies
ogautier62
Valued Contributor II

Re: Two master calendar date son a single chart

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
New Contributor II

Re: Two master calendar date son a single chart

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
Valued Contributor II

Re: Two master calendar date son a single chart

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
New Contributor II

Re: Two master calendar date son a single chart

Thanks