calculate difference

Tue, 13 Aug 2013 05:07:12 GMT

Hi guys,

I have a straight table where i need to find the difference between the values...

Product Name	Month	sum([Actual Value])

AHU	Jan	9368.44
AHU	Feb	8713.27
AHU	Mar	9637.76
Chiller	Jan	38690.87
Chiller	Feb	23797.2
Chiller	Mar	39456.88
Elavator	Jan	548.04
Elavator	Feb	487.34
Elavator	Mar	543.71

From above data i want to find difference between ( jan and feb) ie(8713.27 - 9368.44) values and then between(feb and mar) ie(9637.76 - 8713.27) values and so on...
what expression i need to write....

thanks ,
hitesh

Re: calculate difference

tresB — Tue, 13 Aug 2013 05:10:32 GMT

Use above() function:

Above(Sum([Actual Value])) - sum([Actual Value])

Re: calculate difference

Tue, 13 Aug 2013 05:27:15 GMT

thank you Tres qv

topic calculate difference in QlikView

calculate difference

Re: calculate difference

Re: calculate difference