deviation %

Fri, 10 May 2013 20:47:09 GMT

I use in my chart pivot to accomulate value this expression

RangeSum(Above(TOTAL SUM([field]),0,NoOfRows(TOTAL)))

it'ok and totalize and accomulate for year the value in this method

year 2010 year 2011 %

gen 100 50 -50

feb 200 150 -33,33

mar 350 300 -16,66

apr 400 400 0

How determinate % espression??

Thanks

Re: deviation %

swuehl — Sat, 11 May 2013 11:01:24 GMT

I assume you are using two dimensions in your pivot table, month and year, and 1 expression, right?

This makes it a bit hard to determine % and keep the requested layout.

You can potentially use the partial sum column (activate in presentation tab of chart properties), and select the approproiate expression by a conditional using SecondaryDimensionality() to retrieve the information if the expression evaluated within a details or the partial sum cell.

But I think it's easier here to use a straight table chart, with 1 dimension month and three expression.

Two expressions to calculate your aggregated sums (1 for 2010, 1 for 2011):

=RangeSum(Above(TOTAL SUM({<Year={2010}>} Value),0,NoOfRows(TOTAL)))

=RangeSum(Above(TOTAL SUM({<Year={2011}>} Value),0,NoOfRows(TOTAL)))

and 1 expression to calculate the deviation in percent:

=column(2)/column(1) -1

topic Re: deviation % in QlikView

deviation %

Re: deviation %