Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Costs evolution curve

Hello all,

Here is my problem...

You'll see in the jointed datas, 1 ref, 2 costs and one date...

I'm trying to have a curve, with a time dimension, but, before the date you take the "cout A" and after the date you take the "cout B"...

The tricky thing is that you should have for evry month, the the addition  of each segregated value...

Thanks in advance for your help, and do not hesitate to contact me.

Last but not least... I'm on Qlik Sense.

Laurent

1 Reply
Not applicable
Author

Solution found,

I created a table with the dates and then used a formula:

Sum(if (planning<date,[Cout A],[Cout B]))