Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Antoine
Contributor III
Contributor III

Problem with charts and loading script

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)

Chart from Excel

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:
Month 
-1 Month -1 
-2 Month -2 
-3 Month -3 

 

Thanks by advance for your help,

 

Antoine

4 Replies
Colin-Albert
Partner - Champion
Partner - Champion

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
Contributor III
Contributor III
Author

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
Partner - Champion
Partner - Champion

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

Antoine
Contributor III
Contributor III
Author

How can I do that without TOTAL then ?