How to display a sum depending on begin and end date

olivierrobin — Tue, 26 Jun 2018 09:44:54 GMT

hello

you will find attached a sample application with :

a fact table containing

an id (id_ot)

a date (id_calendar)

2 qty (qty1, qty2)

a dim table with

an id (id_ot)

a budget value (Budget) available between Begin_Date and End_Date

a End_Point value

a calendar table

a sheet containg a graph showing

by month (Mois)

Qty1 and Qty2 for each month

End_Point which is the total amount at the end of the year

All this works perfectly ...

now the problem

I want to display each month the Budget value which is the sum of all Budget for the id_ot such as Begin_Date<=id_mois<=End_Date

I would not like to create another table table with the list of months by id and containing the budget value

Any idea ?

topic How to display a sum depending on begin and end date in QlikView