https://community.qlik.com/t5/QlikView/Generic-Table/m-p/1677827#M449863 <P>Darn....forgot the [] &nbsp; thanks.</P> Thu, 20 Feb 2020 22:00:43 GMT tmumaw 2020-02-20T22:00:43Z https://community.qlik.com/t5/QlikView/Generic-Table/m-p/1677762#M449856 <P>I have built a generic table which looks like this:</P><P>Sold To Customer &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2019 &nbsp; &nbsp; &nbsp; &nbsp; 2020</P><P>12345 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1</P><P>45678 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; -</P><P>67890 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; - &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1</P><P>I need to be able to sum 2019 value and 2020 value and get either 1 or 2, however when I try and construct the sum(2019) + sum(2020)&nbsp; I get 4039.&nbsp; Doing something wrong but not sure what yet.</P><P>Thanks</P> Sat, 16 Nov 2024 19:04:37 GMT https://community.qlik.com/t5/QlikView/Generic-Table/m-p/1677762#M449856 tmumaw 2024-11-16T19:04:37Z https://community.qlik.com/t5/QlikView/Generic-Table/m-p/1677789#M449861 <P>Cant see your data or model but maybe try sum([2019])+sum([2020])</P> Thu, 20 Feb 2020 21:31:00 GMT https://community.qlik.com/t5/QlikView/Generic-Table/m-p/1677789#M449861 jochem_zw 2020-02-20T21:31:00Z https://community.qlik.com/t5/QlikView/Generic-Table/m-p/1677827#M449863 <P>Darn....forgot the [] &nbsp; thanks.</P> Thu, 20 Feb 2020 22:00:43 GMT https://community.qlik.com/t5/QlikView/Generic-Table/m-p/1677827#M449863 tmumaw 2020-02-20T22:00:43Z