Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Solution found,
I created a table with the dates and then used a formula:
Sum(if (planning<date,[Cout A],[Cout B]))