Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Thanks