topic Using existing expressions in new expressions in QlikView https://community.qlik.com/t5/QlikView/Using-existing-expressions-in-new-expressions/m-p/295225#M1192308 <HTML><HEAD></HEAD><BODY><DIV> I have a calculation called Paid FTES.&nbsp; It build off of 4 variables and works correctly.&nbsp; I want to reuse the expression as shown below:</DIV><DIV> </DIV><DIV><SPAN style="font-size: 8pt;"><DIV><SPAN style="font-size: 12pt;">=<SPAN style="color: #0000ff; font-size: 12pt;">sum</SPAN><SPAN style="font-size: 12pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 12pt;">FORECAST_LEVEL_DESC</SPAN><SPAN style="font-size: 12pt;">={'TOTAL FTE'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 12pt;">"Paid FTEs"</SPAN><SPAN style="font-size: 12pt;">) </SPAN></SPAN></DIV></SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 10pt;">If I reference Paid FTEs like this: ="Paid FTEs", I get the result.&nbsp; However, if I wrap it in a sum so that I can push the value down to the children of Total FTE, it comes back blank.</SPAN></DIV><DIV><SPAN style="font-size: 10pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 10pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 10pt;"> </SPAN></DIV></BODY></HTML> Wed, 20 Jul 2011 20:33:41 GMT 2011-07-20T20:33:41Z Using existing expressions in new expressions https://community.qlik.com/t5/QlikView/Using-existing-expressions-in-new-expressions/m-p/295225#M1192308 <HTML><HEAD></HEAD><BODY><DIV> I have a calculation called Paid FTES.&nbsp; It build off of 4 variables and works correctly.&nbsp; I want to reuse the expression as shown below:</DIV><DIV> </DIV><DIV><SPAN style="font-size: 8pt;"><DIV><SPAN style="font-size: 12pt;">=<SPAN style="color: #0000ff; font-size: 12pt;">sum</SPAN><SPAN style="font-size: 12pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 12pt;">FORECAST_LEVEL_DESC</SPAN><SPAN style="font-size: 12pt;">={'TOTAL FTE'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 12pt;">"Paid FTEs"</SPAN><SPAN style="font-size: 12pt;">) </SPAN></SPAN></DIV></SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 10pt;">If I reference Paid FTEs like this: ="Paid FTEs", I get the result.&nbsp; However, if I wrap it in a sum so that I can push the value down to the children of Total FTE, it comes back blank.</SPAN></DIV><DIV><SPAN style="font-size: 10pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 10pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 10pt;"> </SPAN></DIV></BODY></HTML> Wed, 20 Jul 2011 20:33:41 GMT https://community.qlik.com/t5/QlikView/Using-existing-expressions-in-new-expressions/m-p/295225#M1192308 2011-07-20T20:33:41Z