Difference between the same value at different date

[#1]

Hy experts,

I'm new on qlikview.

I have a barshart which display the number of sales by date :

Exemple :

May : 250

June : 200

Jully : 300

My question is how to creat a calculated expression to display the difference between two months ?

x (June/May) = - 50

X (Jully/June) = 100

Could you help me please ?

Regards,

Pierre.

[#2 · Accepted solution]

Hi Pierre,

if you want to show the difference between current and previous month you can use "above" function

sum(Value) - above(sum(Value))

The function will calculate diff from previous dimension value for each value.

Hope this helpes!

Stefan

[#3]

Thanks Stefan, it works

Regards.