Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Costs evolution curve

Solution found,

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

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

Community Browser