topic Re: Summation of two fields in QlikView https://community.qlik.com/t5/QlikView/Summation-of-two-fields/m-p/889669#M1005167 <HTML><HEAD></HEAD><BODY><P>Thanks!!</P></BODY></HTML> Wed, 20 May 2015 09:48:17 GMT 2015-05-20T09:48:17Z Summation of two fields https://community.qlik.com/t5/QlikView/Summation-of-two-fields/m-p/889667#M1005165 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>I want to add two fields,</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">First one is coming from script, I written some logic for it and output of that field is in this format 'HH:MM'.</SPAN></P><P>Second field is subtraction of two different date fields, interval(date1-date2,'hh:mm').</P><P>Here, I want sum of 'HH:MM' and 'hh:mm'.</P><P></P><P>Thanks In advance!!</P></BODY></HTML> Tue, 19 May 2015 15:10:02 GMT https://community.qlik.com/t5/QlikView/Summation-of-two-fields/m-p/889667#M1005165 2015-05-19T15:10:02Z Re: Summation of two fields https://community.qlik.com/t5/QlikView/Summation-of-two-fields/m-p/889668#M1005166 <HTML><HEAD></HEAD><BODY><P>If you are using QV date and time functions to format your value in your first script expression, 'MM' will not return minutes, but month. Please check the Help file for the format codes.</P><P></P><P>Why are you using different format codes?</P><P></P><P>In general, if your values still have a numeric representation, just add the values and format using interval.</P></BODY></HTML> Tue, 19 May 2015 15:56:24 GMT https://community.qlik.com/t5/QlikView/Summation-of-two-fields/m-p/889668#M1005166 swuehl 2015-05-19T15:56:24Z Re: Summation of two fields https://community.qlik.com/t5/QlikView/Summation-of-two-fields/m-p/889669#M1005167 <HTML><HEAD></HEAD><BODY><P>Thanks!!</P></BODY></HTML> Wed, 20 May 2015 09:48:17 GMT https://community.qlik.com/t5/QlikView/Summation-of-two-fields/m-p/889669#M1005167 2015-05-20T09:48:17Z