Yearly Analysis

[Brokenhips]

Possibly posted before but struggling to get to the answer.

Two dates for a given product -

Registration Date

Disposal Date.

Looking for thebest way to compare a count of the products by both dates on a time line, in order to show the purchase vs disposal cycle.

I.e

Registration DateDisposal DateAsset ID

01/01/2016	01/03/2020	123
01/01/2019	01/05/2021	111
23/09/2017	06/10/2024	144

Between date 1 and 2 purchased vs disposal counts of assets?

Thanks in advance

[Ezirraffner]

Hi @Brokenhips 

Maybe a Gantt Chart will help you.

See this extension: GitHub - ralfbecher/QlikSense_Extension_Timeline: QlikSense Extension Timeline

[sunny_talwar]

Look into using IntervalMatch