topic Problem with charts and loading script in QlikView

Problem with charts and loading script

Antoine — Wed, 25 Nov 2020 16:16:04 GMT

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:

Thanks by advance for your help,

Antoine

Colin-Albert — Fri, 23 Nov 2018 14:07:45 GMT

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 — Fri, 23 Nov 2018 14:07:50 GMT

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 — Fri, 23 Nov 2018 14:12:20 GMT

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

Antoine — Fri, 23 Nov 2018 14:14:03 GMT

How can I do that without TOTAL then ?