Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Specialist III
Specialist III

How to display a sum depending on begin and end date


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 ?

0 Replies