topic Re: adding fields in QlikView https://community.qlik.com/t5/QlikView/adding-fields/m-p/797220#M281625 <HTML><HEAD></HEAD><BODY><P>What do you mean 'add up'. Strings don't add up very well. Numbers work a lot better. If you want to concatenate the string values you can use the concat function:</P><P></P><P>LOAD case, <STRONG>concat(description, '\')</STRONG> as description_list</P><P>FROM ...</P><P>GROUP BY case;</P></BODY></HTML> Fri, 30 Jan 2015 12:54:22 GMT Gysbert_Wassenaar 2015-01-30T12:54:22Z adding fields https://community.qlik.com/t5/QlikView/adding-fields/m-p/797219#M281624 <HTML><HEAD></HEAD><BODY><P>Guys i have the following case (see attached the 2 excel files). I want to find a way to add up the fields having the same case id</P></BODY></HTML> Fri, 30 Jan 2015 12:39:19 GMT https://community.qlik.com/t5/QlikView/adding-fields/m-p/797219#M281624 2015-01-30T12:39:19Z Re: adding fields https://community.qlik.com/t5/QlikView/adding-fields/m-p/797220#M281625 <HTML><HEAD></HEAD><BODY><P>What do you mean 'add up'. Strings don't add up very well. Numbers work a lot better. If you want to concatenate the string values you can use the concat function:</P><P></P><P>LOAD case, <STRONG>concat(description, '\')</STRONG> as description_list</P><P>FROM ...</P><P>GROUP BY case;</P></BODY></HTML> Fri, 30 Jan 2015 12:54:22 GMT https://community.qlik.com/t5/QlikView/adding-fields/m-p/797220#M281625 Gysbert_Wassenaar 2015-01-30T12:54:22Z Re: adding fields https://community.qlik.com/t5/QlikView/adding-fields/m-p/797221#M281626 <HTML><HEAD></HEAD><BODY><P>Thanks for your support</P></BODY></HTML> Fri, 30 Jan 2015 12:59:59 GMT https://community.qlik.com/t5/QlikView/adding-fields/m-p/797221#M281626 2015-01-30T12:59:59Z