topic Use field as expression in QlikView https://community.qlik.com/t5/QlikView/Use-field-as-expression/m-p/240627#M91131 <HTML><HEAD></HEAD><BODY><P>Create a variable that looks like this:</P><P>=Formula</P><P>Then in the expression of the report put $(Variable). This will expand the formula first and then calculate it.</P><P>Regards.</P></BODY></HTML> Mon, 18 Oct 2010 18:18:49 GMT pover 2010-10-18T18:18:49Z Use field as expression https://community.qlik.com/t5/QlikView/Use-field-as-expression/m-p/240626#M91130 <HTML><HEAD></HEAD><BODY><P>I have a table that has two fields. one is Report no, the other has a formula in it. (called Formula)</P><P>For example Report 1, Sum(Value). Can I use the Formula field as an expression. I keep getting a no data to dipslay error message.</P></BODY></HTML> Mon, 18 Oct 2010 17:50:45 GMT https://community.qlik.com/t5/QlikView/Use-field-as-expression/m-p/240626#M91130 alan_grn 2010-10-18T17:50:45Z Use field as expression https://community.qlik.com/t5/QlikView/Use-field-as-expression/m-p/240627#M91131 <HTML><HEAD></HEAD><BODY><P>Create a variable that looks like this:</P><P>=Formula</P><P>Then in the expression of the report put $(Variable). This will expand the formula first and then calculate it.</P><P>Regards.</P></BODY></HTML> Mon, 18 Oct 2010 18:18:49 GMT https://community.qlik.com/t5/QlikView/Use-field-as-expression/m-p/240627#M91131 pover 2010-10-18T18:18:49Z Use field as expression https://community.qlik.com/t5/QlikView/Use-field-as-expression/m-p/240628#M91132 <HTML><HEAD></HEAD><BODY><P>Thanks. It was the = in the formula that was missing.</P></BODY></HTML> Mon, 18 Oct 2010 18:26:46 GMT https://community.qlik.com/t5/QlikView/Use-field-as-expression/m-p/240628#M91132 alan_grn 2010-10-18T18:26:46Z