topic Variance in a Bar Chart in QlikView

Variance in a Bar Chart

Tue, 12 Mar 2013 20:03:22 GMT

Hi,

I'm trying to create a combo chart which shows the % annual growth of sales (like the blue line in the image).

The values on data points aren't that important, my question is how can I make this line.

I tryed use set analysis with current year - current year-1 but doesn't worked.

My idea is to use a Dimension Group with Year and Month to show the variance when the user interact with the chart.

Tue, 12 Mar 2013 20:21:29 GMT

Hi,

Try with this:

(sum(Field) - Above(sum(Field))) / Above(Sum(Field))

Above() function gets the previous value.

Regards,

Ricardo

Tue, 12 Mar 2013 20:36:24 GMT

Use:

=sum(Sales)/above(sum(Sales))-1