Create Line Chart with 2 date fields.

[Sam_Thomas]

Hi. 

I wish to create a line chart using two date fields. I wanted to compare, month by month, the number of completed jobs (actual date) against the number of scheduled/planned jobs (scheduled date) Below is a sample of my data. 

Actual_Date	Scheduled_Date	Equip_Number
01/03/2023	28/01/2023	23
15/02/2023	28/02/2023	67
18/10/2022	16/12/2022	12
14/01/2023	20/12/2022	90

Thanks

[Chanty4u]

Hi you can try this 

=Count({<Actual_Date={"$(=MonthStart(Max(Actual_Date)))"}>} Equip_Number)

=Count({<Scheduled_Date={"$(=MonthStart(Max(Scheduled_Date)))"}>} Equip_Number)

[Sam_Thomas]

Thank you for your response. 

Where do I put these expressions? Are they the for the individual measures? If so, what do I use as the Dimension? As I assume I need a date field, but these are the only two date fields I have. I don't have a generic calendar to use (as far as I'm aware)

[Qrishna]

Your ask is a bit unclear.

can you roughly provide youR output picture?

[Sam_Thomas]

Sorry. 

I don't have an output picture as I don't have the correct expression to create the chart. 

I want to count the number of jobs that were completed, vs the number of jobs that were expected, per month. 

see below for source/raw data and see underneath for a table version of what I would like to see visualised in the a chart. 

Raw Data

Actual_Date	Scheduled_Date	Equip_Number
01/03/2023	28/01/2023	23
15/02/2023	28/02/2023	67
18/10/2022	16/12/2022	12
14/01/2023	20/12/2022	90
02/03/2023	04/12/2022	45
01/11/2022	07/01/2023	11
28/01/2023	01/01/2023	87
18/02/2023	02/02/2023	58
16/10/2022	18/01/2023	91
19/12/2022	20/12/2022	20

Summarised Data

MonthYear	Count of Actual Date	Count of Scheduled Date
Oct 2022	2	0
Nov 2022	1	0
Dec 2022	1	4
Jan 2023	2	4
Feb 2023	2	2
Mar 2023	1	0

I would like to visualise the above data in the form of a line chart where one line is the count of the actual date and one line is the count of the scheduled date, with the X axis being the monthyear

Thanks

[Rohan]

Hi,

I think you will have to use Island or Unlinked Calendar to achieve the desired output. Kindly refer the following link :

https://cassio-bolba.medium.com/date-island-qlik-sense-25ea793aca2d

Let me know in case of any queries.

Thanks & Regards,

Rohan.