Assign Cost to Years

[qlikwiz123]

Here is my sample data:

Expected Output:

I need to assign Cost to every year from Start year to end Year from the Date.

Cost per ID is 4. Since Year - 2021 has 6 IDs, Cost for 2021 should be 4x6=24.

Since there are no IDs for the year - 2022, Cost for 2022 should be 0.

Similarly, for 2023, Cost is 0 since there are no IDs in that year.

For Year - 2024, the cost is 4 since there is only one ID in that Year.

How do I achieve this and show this in a Straight Table and a Bar Chart?

I have attached my Sample QVW for reference. Any help is highly appreciated 🙂 

[Taoufiq_Zarra · Accepted solution]

@qlikwiz123 

Maye be like attached

[qlikwiz123]

@Taoufiq_Zarra  Thank you so much