5 Replies Latest reply: Oct 18, 2011 8:23 AM by fmst44000

Visualise the accumulation in a chart bar

fmst44000 Oct 18, 2011 6:40 AM

Hello,

I'm using a bar chart : is there any way to make the accumulation visible ?

This is what I want : per year, I need to count a number of products.

2008 : 1

2009 : 2

2010 : 3

That's great. I select the "Full accumulation", and it gives me :

2008 : 1

2009 : 3

2010 : 6

OK, but the bars are all in the same color, and I can't tell wich is the number of products of the year and which is the accumated part...

Don't know if I'm clear...

I would like to have one portion for the numbert of products of the year and another portion, in another color, for the accumulated products of the previous years (of course, stacked).

Is there any way to do that ?

Thanks,

Fred

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.

Miguel Angel Baeyens
BI Consultant
Comex Grupo Ibérica
Like Show 0 Likes (0)

Actions
- 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
  
  Like Show 0 Likes (0)
  
  Actions
  - 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.
    
    Miguel Angel Baeyens
    BI Consultant
    Comex Grupo Ibérica
    
    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
    
    Like Show 0 Likes (0)
    
    Actions
    - 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
      
      Like Show 0 Likes (0)
      
      Actions
    - 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
      
      Like Show 1 Like (1)
      
      Actions

Go to original post