Assign Cost to Years

qlikwiz123 — Sat, 16 Nov 2024 17:40:19 GMT

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 🙂

Re: Assign Cost to Years

Taoufiq_Zarra — Thu, 24 Dec 2020 09:09:52 GMT

Maye be like attached

qlikwiz123 — Tue, 29 Dec 2020 03:46:36 GMT

@Taoufiq_Zarra Thank you so much