topic Re: Simple arithmetic between columns in QlikView https://community.qlik.com/t5/QlikView/Simple-arithmetic-between-columns/m-p/1118357#M888061 <HTML><HEAD></HEAD><BODY><P>Simple yet effective.</P><P></P><P>Thank you! I was breaking it down into individual sums. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Cheers, much appreciated!</P></BODY></HTML> Wed, 31 Aug 2016 09:25:04 GMT 2016-08-31T09:25:04Z Simple arithmetic between columns https://community.qlik.com/t5/QlikView/Simple-arithmetic-between-columns/m-p/1118355#M888059 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Lets say there's column 1: start and column 2: end</P><P></P><P>I want to subtract start from end to get a new value to add as a measure in a qlik chart.</P><P></P><P>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.</P><P></P><P>Can someone point me to some documentation on writing calculations/functions?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Simple-arithmetic-between-columns/m-p/1118355#M888059 2020-11-25T16:16:04Z Re: Simple arithmetic between columns https://community.qlik.com/t5/QlikView/Simple-arithmetic-between-columns/m-p/1118356#M888060 <HTML><HEAD></HEAD><BODY><P>=sum([End] - [Start])</P></BODY></HTML> Wed, 31 Aug 2016 09:16:44 GMT https://community.qlik.com/t5/QlikView/Simple-arithmetic-between-columns/m-p/1118356#M888060 Gysbert_Wassenaar 2016-08-31T09:16:44Z Re: Simple arithmetic between columns https://community.qlik.com/t5/QlikView/Simple-arithmetic-between-columns/m-p/1118357#M888061 <HTML><HEAD></HEAD><BODY><P>Simple yet effective.</P><P></P><P>Thank you! I was breaking it down into individual sums. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Cheers, much appreciated!</P></BODY></HTML> Wed, 31 Aug 2016 09:25:04 GMT https://community.qlik.com/t5/QlikView/Simple-arithmetic-between-columns/m-p/1118357#M888061 2016-08-31T09:25:04Z