Problem with charts and loading script

[Antoine]

Hello,

I want to "convert" a chart from Excel into Qlik, and I'm struggling with it...

Here's the following chart:

(For now I just need the blue part and the green part)

I've actually been able to create the blue part easily, but now I'm struggling for the greenpart:

It says how actions are "outdated" and since when, and it's a cumulative sum.

I've been able to create 4 different measurements for the outdated actions, one per month:

Month   : Sum({<[Date Délai.autoCalendar.MonthsAgo]={">=0"}>}TOTAL[Si = 1, action en retard])

Month-1 : Sum({<[Date Délai.autoCalendar.MonthsAgo]={">=1"}>}TOTAL[Si = 1, action en retard])

Month-2 : Sum({<[Date Délai.autoCalendar.MonthsAgo]={">=2"}>}TOTAL[Si = 1, action en retard])

Month-3 : Sum({<[Date Délai.autoCalendar.MonthsAgo]={">=3"}>}TOTAL[Si = 1, action en retard])

But when I add them to the chart, I get all the value for each and every month:

The main question is:

How could I create a table at the loading, with like:

Month N°	Outdated actions:
0	Month
-1	Month -1
-2	Month -2
-3	Month -3

Thanks by advance for your help,

Antoine

[Colin-Albert]

Check on the General Tab that your chart is a Combo chart.

Then on the Expressions tab set whether each expression is shown as a bar or line.

Finally on the Style tab set  as Stacked

[Antoine]

That's not really the solution, I'll end up with the value of Month-3 + Month-2 + Month-1 + Month for every month...

I need to have the measurement of

Month-3 (light blue) only for 2018-aout

Month-2 (green) only for 2018-septembre

Month-1 (yellow) only for 2018-octobre

Month (pink) only for 2018-Novembre

[Colin-Albert]

You're using the same TOTAL expression for each measure, hence the same result for each month.

[Antoine]

How can I do that without TOTAL then ?