Simple arithmetic between columns

[#1]

I am testing a gauge chart, with data being fed from a database. I want to perform a subtraction between two values in their respective columns.

Lets say there's column 1: start and column 2: end

I want to subtract start from end to get a new value to add as a measure in a qlik chart.

I can only add a single measure at any one time, so I thought of adding the end column first and then playing around with the function syntax to see if i can modify it, but to no avail.

Can someone point me to some documentation on writing calculations/functions?

Thanks

[Gysbert_Wassenaar · Accepted solution]

=sum([End] - [Start])

[#3]

Simple yet effective.

Thank you! I was breaking it down into individual sums. 🙂

Cheers, much appreciated!