Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculate difference

Hi guys,

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

Product NameMonthsum([Actual Value])
AHUJan9368.44
AHUFeb8713.27
AHUMar9637.76
ChillerJan38690.87
ChillerFeb23797.2
ChillerMar39456.88
ElavatorJan548.04
ElavatorFeb487.34
ElavatorMar543.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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Use above() function:

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

View solution in original post

2 Replies
tresesco
MVP
MVP

Use above() function:

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

Not applicable
Author

thank you Tres qv