-
Visualise the accumulation in a chart bar
Miguel Angel Baeyens de Arce Oct 18, 2011 6:40 AM (in response to fmst44000)Hi Fred,
Use the same expression twice. In the first one set it to not accumulate so you will see each year with their products. In the second expression set it to full accumulation, so you see this year and all the previous summed up.
Hope that helps.
BI Consultant
-
Visualise the accumulation in a chart bar
fmst44000 Oct 18, 2011 7:06 AM (in response to Miguel Angel Baeyens de Arce )Hi Miguel,
Thanks for your answer.
I have modify the expressions according to your advice and this is what I get :
That's a good start but the result is not correct. Blue part is OK, but the red one (the accumlated) is not good because it includes not only the total of products of the previous years but also the total of the year.
I will try and search how to solve this.
If you have an idea, I'm all ears (or eyes) !
Fred
-
Re: Visualise the accumulation in a chart bar
Miguel Angel Baeyens de Arce Oct 18, 2011 7:18 AM (in response to fmst44000)Hi Fred,
That is exactly what Full Accumulation does: sum up the current expression value to all the previous values. You can use the RangeSum() function along with Before() or similar to sum up all previous values except for this year. Check this post in this regard.
Hope that helps.
BI Consultant
EDIT: Example file updated using the following expression to accumulate except for this year
RangeSum(Above(Sum(Amount), 1, RowNo()))
-
qcomRangeSumUntilThis.qvw 153.5 K
-
Visualise the accumulation in a chart bar
fmst44000 Oct 18, 2011 8:19 AM (in response to Miguel Angel Baeyens de Arce )Hi Miguel,
As I'm new to QlikView, I will need some time to adapt your example to my case.
I will let you know when I succeed !
Thanks again,
Fred
-
Visualise the accumulation in a chart bar
fmst44000 Oct 18, 2011 8:23 AM (in response to Miguel Angel Baeyens de Arce )You are really great !
Thank you very much for your example, seems to work fine for me !
(I hope one day I will be as great as you... I reckon it will take some time )
Fred
-
-
-