topic Suming Multiple fields in QlikView https://community.qlik.com/t5/QlikView/Suming-Multiple-fields/m-p/218565#M71660 <HTML><HEAD></HEAD><BODY><P>Try something like:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />Load<BR />num(EQUIP)+ num(LABOR) + num(PARTS) +num(OTHER) as NewFieldName<BR />from...<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>What happens?</P></BODY></HTML> Wed, 16 Feb 2011 14:38:31 GMT Anonymous 2011-02-16T14:38:31Z Suming Multiple fields https://community.qlik.com/t5/QlikView/Suming-Multiple-fields/m-p/218564#M71659 <HTML><HEAD></HEAD><BODY><P>I have a table where I need to add four fields in order to create the necessary total. The field names are EQUIP, LABOR, PARTS,and OTHER. I tried a few different sum configurations but they don't return any data. Please help with the formula.</P><P></P><P>Thanx</P><P></P></BODY></HTML> Wed, 16 Feb 2011 14:32:55 GMT https://community.qlik.com/t5/QlikView/Suming-Multiple-fields/m-p/218564#M71659 2011-02-16T14:32:55Z Suming Multiple fields https://community.qlik.com/t5/QlikView/Suming-Multiple-fields/m-p/218565#M71660 <HTML><HEAD></HEAD><BODY><P>Try something like:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />Load<BR />num(EQUIP)+ num(LABOR) + num(PARTS) +num(OTHER) as NewFieldName<BR />from...<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>What happens?</P></BODY></HTML> Wed, 16 Feb 2011 14:38:31 GMT https://community.qlik.com/t5/QlikView/Suming-Multiple-fields/m-p/218565#M71660 Anonymous 2011-02-16T14:38:31Z Suming Multiple fields https://community.qlik.com/t5/QlikView/Suming-Multiple-fields/m-p/218566#M71661 <HTML><HEAD></HEAD><BODY><P>Dennis,</P><P>That doesn't seem to work.....it loads the table fine, but doesn't like the load statement. Is there a way the summation can be created in the chart expression?</P></BODY></HTML> Wed, 16 Feb 2011 15:06:36 GMT https://community.qlik.com/t5/QlikView/Suming-Multiple-fields/m-p/218566#M71661 2011-02-16T15:06:36Z Suming Multiple fields https://community.qlik.com/t5/QlikView/Suming-Multiple-fields/m-p/218567#M71662 <HTML><HEAD></HEAD><BODY><P>Normaly that should work the same way.<BR />Can you upload the file so I can have a look?</P></BODY></HTML> Wed, 16 Feb 2011 15:13:42 GMT https://community.qlik.com/t5/QlikView/Suming-Multiple-fields/m-p/218567#M71662 Anonymous 2011-02-16T15:13:42Z Suming Multiple fields https://community.qlik.com/t5/QlikView/Suming-Multiple-fields/m-p/218568#M71663 <HTML><HEAD></HEAD><BODY><P>On a Script????</P><P>Maybe not recognized as number.</P><P>Evaluate(sum(EQUIP))+Evaluate(sum(LABOR)+..... as NewFileName</P></BODY></HTML> Wed, 16 Feb 2011 15:28:40 GMT https://community.qlik.com/t5/QlikView/Suming-Multiple-fields/m-p/218568#M71663 2011-02-16T15:28:40Z