topic Re: How to write the Expression for Subtraction and multiplication? in QlikView https://community.qlik.com/t5/QlikView/How-to-write-the-Expression-for-Subtraction-and-multiplication/m-p/802869#M472888 <HTML><HEAD></HEAD><BODY><P>Rather:</P><P>=( sum(Time1) - sum(Time2) ) * 4</P><P>- Ralf</P></BODY></HTML> Wed, 10 Dec 2014 06:44:06 GMT rbecher 2014-12-10T06:44:06Z How to write the Expression for Subtraction and multiplication? https://community.qlik.com/t5/QlikView/How-to-write-the-Expression-for-Subtraction-and-multiplication/m-p/802866#M472885 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P>I am facing the same problem in my development, but i need to subtrct the two row from different columns in the same table.</P><P>Example:</P><P>Time 1 Time 2</P><P>3 2</P><P>6 3</P><P>Tatal 9 5 =4 (9-5)</P><P style="padding: 0px; min-height: 8pt;"></P><P>Can you please suggest how can i write expression for 9-5= 4 and Multply 4 with some other number like 4*9=36.</P><P style="padding: 0px; min-height: 8pt;"></P><P style="padding: 0px; min-height: 8pt;"></P><P>Thanks</P><P>Bhupal</P></BODY></HTML> Wed, 10 Dec 2014 06:38:06 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-Expression-for-Subtraction-and-multiplication/m-p/802866#M472885 Anonymous 2014-12-10T06:38:06Z Re: How to write the Expression for Subtraction and multiplication? https://community.qlik.com/t5/QlikView/How-to-write-the-Expression-for-Subtraction-and-multiplication/m-p/802867#M472886 <HTML><HEAD></HEAD><BODY><P>Hi Bhupal,</P><P></P><P>You can use total function i.e</P><P>Total(Sum(time1))- total(sum(time2)</P><P></P><P>and for the multiplication with other number</P><P>Total(Sum(time1))- total(sum(time2) * 4 (any number you wnat)</P></BODY></HTML> Wed, 10 Dec 2014 06:41:16 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-Expression-for-Subtraction-and-multiplication/m-p/802867#M472886 2014-12-10T06:41:16Z Re: How to write the Expression for Subtraction and multiplication? https://community.qlik.com/t5/QlikView/How-to-write-the-Expression-for-Subtraction-and-multiplication/m-p/802868#M472887 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/58048">Substract 2 different rows of a single table</A></P></BODY></HTML> Wed, 10 Dec 2014 06:42:44 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-Expression-for-Subtraction-and-multiplication/m-p/802868#M472887 anbu1984 2014-12-10T06:42:44Z Re: How to write the Expression for Subtraction and multiplication? https://community.qlik.com/t5/QlikView/How-to-write-the-Expression-for-Subtraction-and-multiplication/m-p/802869#M472888 <HTML><HEAD></HEAD><BODY><P>Rather:</P><P>=( sum(Time1) - sum(Time2) ) * 4</P><P>- Ralf</P></BODY></HTML> Wed, 10 Dec 2014 06:44:06 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-Expression-for-Subtraction-and-multiplication/m-p/802869#M472888 rbecher 2014-12-10T06:44:06Z Re: How to write the Expression for Subtraction and multiplication? https://community.qlik.com/t5/QlikView/How-to-write-the-Expression-for-Subtraction-and-multiplication/m-p/802870#M472889 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>My problem is solved.</P><P></P><P>Thank You ! </P><P></P><P></P><P>BR</P><P>Bhupal</P></BODY></HTML> Wed, 10 Dec 2014 08:46:57 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-Expression-for-Subtraction-and-multiplication/m-p/802870#M472889 Anonymous 2014-12-10T08:46:57Z