topic Relative percentage in a pivot table in QlikView

Relative percentage in a pivot table

Mon, 23 Apr 2012 13:30:53 GMT

Hello,

I have a pivot table with Sales figures against a corresponding year.

Ynum Year Sales

Y1 2000 9876896

Y2 2001 9069876

Y3 2002 6986986

Need to calculate

Y2/Y1

Y3/Y2

...

I need to calculate a year on year evolution. The problem is that adding an expression to the pivot table only ads vertical columns, which doesnt let me use the ABOVE() function to calculate the relative percentage with regard to the previous year.

Any ideas?

Thanks in advance,

Regards

Relative percentage in a pivot table

SunilChauhan — Mon, 23 Apr 2012 13:42:04 GMT

calculate Y1 value in first expression

calculate Y2 value in second expression

calculate Y3 value in third expression

then in forth expression

column(2)/column(1)

in fifth

column(3)/column(2)

hope this helps

Relative percentage in a pivot table

CELAMBARASAN — Mon, 23 Apr 2012 13:44:40 GMT

Hi,

Check with this

Sum(Sales)/Above(Sum(Sales))

Celambarasan

Relative percentage in a pivot table

Mon, 23 Apr 2012 13:59:46 GMT

Hello Celambarasan Adhimulam

Indeed this is what I tried, but adding this calculation Sum(Sales)/Above(Sum(Sales)) to the expression ads a column after the sales column and not as a row below years. And so it is not calculating correctly the ABOVE().

Re: Relative percentage in a pivot table

Mon, 23 Apr 2012 20:00:57 GMT

If you are trying a multi-dimensional table, the expression should be: sum(Sales)/above(total sum(Sales)). Then it appears to work as you desire.

Re: Relative percentage in a pivot table

Tue, 24 Apr 2012 08:11:38 GMT

I think it was the Total, it works fine!

Thanks a lot!

Cheers!