Evolution in time of data with start and stop date

[Christophe_Luycx]

Hello all,

How is it possible to have the evolution over time of data with start and stop date ?

Where that data has to be taken in account between those dates.

In my data set, every row has those informations :

• State (Active or Old)
• Start date
• Stop date
• Amount

I would like to have a graph which follows the evolution of the average of the Amount over time. At any date, the average of the amount must be calculated based on the Start date ans the Stop date.

For example :

State	Added date	Old date	Amount
Old	08-10-2022	14-10-2022	30
Active	10-10-2022		20
Active	12-10-2022		70

*Old date can be set to today's date to help

We sould have that graph :

I hope it is clear for you to understand,

Thanks for your help

[SharkeyNZ]

I have a similar problem trying to measure the amount of open tickets over time, and to represent this in a graph.

Ticket	Start Date	End Date	Status
T1	2023-01-01	2023-01-07	Closed
T2	2023-01-02	2023-01-14	Closed
T3	2023-01-05	2023-01-10	Closed
T4	2023-01-10		Open
T5	2023-01-15	2023-01-20	Closed
T6	2023-01-16	2023-01-17	Closed

I want to count the number of open tickets over time, so the graph would look like below.

If I was doing this in PowerBI, I'd create a separate time Dimension, not connected to the main Fact table, and add a measure or column on that separate Dimension that counts all Tickets, where for a specific date x, the Start date <= and the Close date is either empty or greater the x.  I could then plot the date from that dimension and the measure.  But I'm at a loss on how to achieve this in Qlik.