topic Re: Expression Calculation - Variable name in QlikView https://community.qlik.com/t5/QlikView/Expression-Calculation-Variable-name/m-p/462211#M485264 <HTML><HEAD></HEAD><BODY><P>Of course you can. In your case Column 1 = vDate_From.... and Column 2 = Date(VDate_From...</P><P></P><P>In variance do: (column(1) - Column(2))/Column(1)</P></BODY></HTML> Wed, 15 May 2013 13:37:07 GMT jvitantonio 2013-05-15T13:37:07Z Expression Calculation - Variable name https://community.qlik.com/t5/QlikView/Expression-Calculation-Variable-name/m-p/462209#M485262 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="41114" class="jive-image-thumbnail jive-image" onclick="" alt="Column Calculation.png" src="/legacyfs/online/41114_Column Calculation.png" width="450" /></P><P></P><P>Hi i have the following scenario whereby i have used my variables as headerlines.</P><P>i would now like to make a calculation based on these two expressions</P><P></P><P>ie. (Expression1- Expression2)/ Expression1</P><P></P><P>can these expressions be used as Column1 and Column2, i have such complex names because of the the variables that it doesnt work.</P><P></P><P>Best,</P><P>Brad</P></BODY></HTML> Wed, 15 May 2013 11:32:29 GMT https://community.qlik.com/t5/QlikView/Expression-Calculation-Variable-name/m-p/462209#M485262 2013-05-15T11:32:29Z Re: Expression Calculation - Variable name https://community.qlik.com/t5/QlikView/Expression-Calculation-Variable-name/m-p/462210#M485263 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm not sure I understand your requirement. Do you want to use the columns of the pivot table in other expressions? If so then you can use the shortcut of '=Column(1)' for example - although I'd be wary of this approach as it breaks if you move the column order.</P></BODY></HTML> Wed, 15 May 2013 13:31:12 GMT https://community.qlik.com/t5/QlikView/Expression-Calculation-Variable-name/m-p/462210#M485263 juleshartley 2013-05-15T13:31:12Z Re: Expression Calculation - Variable name https://community.qlik.com/t5/QlikView/Expression-Calculation-Variable-name/m-p/462211#M485264 <HTML><HEAD></HEAD><BODY><P>Of course you can. In your case Column 1 = vDate_From.... and Column 2 = Date(VDate_From...</P><P></P><P>In variance do: (column(1) - Column(2))/Column(1)</P></BODY></HTML> Wed, 15 May 2013 13:37:07 GMT https://community.qlik.com/t5/QlikView/Expression-Calculation-Variable-name/m-p/462211#M485264 jvitantonio 2013-05-15T13:37:07Z