Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sunil_Kenth
Former Employee
Former Employee

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

1 Solution

Accepted Solutions
Not applicable

Hi,

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

C u,

Stefano

View solution in original post

2 Replies
Not applicable

Hi,

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

C u,

Stefano

Sunil_Kenth
Former Employee
Former Employee
Author

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