Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

skh
Contributor

Calculate % Difference

Can someone please tell me why i am getting strange results in QV when trying to calculate % difference? 

I need to find the difference in sales figuers from 2010 to 2011

Here is the expression i am using:

=((Sum({$<YEAR={'2011'}>} NET_USD) - Sum({$<YEAR={'2010'}>} NET_USD)) / (Sum({$<YEAR={'2010'}>} NET_USD))*100)

From my understanding to calculate % difference you need to:

1. Minus the old from the new

2. Divide what is left by the old value

3. Multiply what is left by 100.

The sales figures i have are 2010 = $94 and 2011 = $180.  The % difference figure i should get is 91.49% but in QV I get -122% and i can't understand why.

Any ideas???

Thanks,

Sunil

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Calculate % Difference

Hi,

it seems to be correct.. have you some selection that interfree?

C u,

Stefano

View solution in original post

2 Replies
Not applicable

Calculate % Difference

Hi,

it seems to be correct.. have you some selection that interfree?

C u,

Stefano

View solution in original post

skh
Contributor

Calculate % Difference

Thanks Stefano - after a detailed look into the expressions i was using, you were correct, i wasn't comparing apples with apples!

The above expression IS correct.

Thanks for replying.

Sunil