Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
You're using the same TOTAL expression for each measure, hence the same result for each month.
How can I do that without TOTAL then ?