topic Syntax to use variable to form field name in Sum formula in QlikView https://community.qlik.com/t5/QlikView/Syntax-to-use-variable-to-form-field-name-in-Sum-formula/m-p/972948#M966629 <HTML><HEAD></HEAD><BODY><P>Hi Qlikviewers,</P><P></P><P>I have&nbsp; a series of field names in my data load [May Revenue], [Jun Revenue], [Jul Revenue], etc.</P><P></P><P>The field is used in a simple Sum formula, example =Sum ([May Revenue]), but instead of hard coding the formula for each month, I want to allow the user to specify the month and the value is saved in a variable (vMonth).&nbsp; This variable should be combined with the word "Revenue" to form one of the field names above and used in a Sum formula.&nbsp; Ideally, it would be something like this =Sum(vMonth&amp;"Revenue").</P><P></P><P>How would I be able to accomplish this?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 30 Sep 2015 23:57:30 GMT 2015-09-30T23:57:30Z Syntax to use variable to form field name in Sum formula https://community.qlik.com/t5/QlikView/Syntax-to-use-variable-to-form-field-name-in-Sum-formula/m-p/972948#M966629 <HTML><HEAD></HEAD><BODY><P>Hi Qlikviewers,</P><P></P><P>I have&nbsp; a series of field names in my data load [May Revenue], [Jun Revenue], [Jul Revenue], etc.</P><P></P><P>The field is used in a simple Sum formula, example =Sum ([May Revenue]), but instead of hard coding the formula for each month, I want to allow the user to specify the month and the value is saved in a variable (vMonth).&nbsp; This variable should be combined with the word "Revenue" to form one of the field names above and used in a Sum formula.&nbsp; Ideally, it would be something like this =Sum(vMonth&amp;"Revenue").</P><P></P><P>How would I be able to accomplish this?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 30 Sep 2015 23:57:30 GMT https://community.qlik.com/t5/QlikView/Syntax-to-use-variable-to-form-field-name-in-Sum-formula/m-p/972948#M966629 2015-09-30T23:57:30Z