topic How to reuse an expression without repeating code? in QlikView https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190959#M53243 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>In your expression, to reuse one you've already created, you can use column(x) function.</P><P>It's very useful.</P><P></P><P>Hope this helps,</P><P>Yamaz</P></BODY></HTML> Fri, 28 Jan 2011 09:32:48 GMT 2011-01-28T09:32:48Z How to reuse an expression without repeating code? https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190957#M53241 <HTML><HEAD></HEAD><BODY><P>Hello everyone. I need help.<BR />I created an expression and I have added to the PivotTable (field "VALUE").<BR />Since I use this expression in different parts of the project I thought<BR />create a variable and move the contents of the expression in there (VAR_NUMERATORE).<BR /><BR />However, adding a column of type expression containing the variable created in<BR />PivotTable I realized that the data will not be calculated as I want.<BR /><BR />The result is that I would get represented in the "VALUE" column, while the wrong one<BR />I would fix is in column "CALC_VALUE".<BR /><BR />Does anyone have any suggestions?<BR /><BR />Thanks for your support and sorry for my google-translated English [:)],</P><P>Capetto</P></BODY></HTML> Fri, 28 Jan 2011 09:20:52 GMT https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190957#M53241 2011-01-28T09:20:52Z How to reuse an expression without repeating code? https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190958#M53242 <HTML><HEAD></HEAD><BODY><P>Opsss... Here the example.</P></BODY></HTML> Fri, 28 Jan 2011 09:24:06 GMT https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190958#M53242 2011-01-28T09:24:06Z How to reuse an expression without repeating code? https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190959#M53243 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>In your expression, to reuse one you've already created, you can use column(x) function.</P><P>It's very useful.</P><P></P><P>Hope this helps,</P><P>Yamaz</P></BODY></HTML> Fri, 28 Jan 2011 09:32:48 GMT https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190959#M53243 2011-01-28T09:32:48Z How to reuse an expression without repeating code? https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190960#M53244 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Correct expreesion of VALUE like this :</P><P></P><P>=Sum(</P><P>If(INDICATORE='A001' OR INDICATORE='A003' OR INDICATORE='A005' OR INDICATORE='A007' OR INDICATORE='A009' OR INDICATORE='A011',</P><P>(If(VALORE &gt;= VALORE_MIN AND VALORE &lt;= VALORE_MAX, VALORE,0)),</P><P>If(INDICATORE='A002' OR INDICATORE='A004' OR INDICATORE='A006' OR INDICATORE='A008' OR INDICATORE='A010',</P><P>(If(VALORE &gt;= VALORE_MIN AND VALORE &lt;= VALORE_MAX, 1,0)))))</P><BR /><BR /> <P></P><P>and then CAL_VALUE give it in Expression popup =[VALUE]</P><P></P><P>may it will gives you correct answer</P><P></P><P>Regards,</P><P>Santhosh</P></BODY></HTML> Fri, 28 Jan 2011 09:45:26 GMT https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190960#M53244 2011-01-28T09:45:26Z How to reuse an expression without repeating code? https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190961#M53245 <HTML><HEAD></HEAD><BODY><P>Column(x) function can be used only in the same object. I need to use this expression in another objects (graphics and tables).</P><P>Capetto</P></BODY></HTML> Fri, 28 Jan 2011 09:53:40 GMT https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190961#M53245 2011-01-28T09:53:40Z How to reuse an expression without repeating code? https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190962#M53246 <HTML><HEAD></HEAD><BODY><P>Please find the attachment and find the differences of Variable (usage. '=' and '$' usage specially).</P><P>regards, tresesco</P></BODY></HTML> Fri, 28 Jan 2011 10:06:09 GMT https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190962#M53246 tresB 2011-01-28T10:06:09Z How to reuse an expression without repeating code? https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190963#M53247 <HTML><HEAD></HEAD><BODY><P>Perfect!!! It works very well.</P><P>Thank you very much,</P><P>Capetto</P></BODY></HTML> Fri, 28 Jan 2011 10:51:30 GMT https://community.qlik.com/t5/QlikView/How-to-reuse-an-expression-without-repeating-code/m-p/190963#M53247 2011-01-28T10:51:30Z