topic Searching in a table in QlikView https://community.qlik.com/t5/QlikView/Searching-in-a-table/m-p/217851#M71025 <HTML><HEAD></HEAD><BODY><P>To use a formula from an external source use the $(formula_field)</P><P>Also noticed you need to remove the space after the =</P><P>= Sum</P><P>=Sum</P></BODY></HTML> Thu, 09 Dec 2010 01:35:06 GMT 2010-12-09T01:35:06Z Searching in a table https://community.qlik.com/t5/QlikView/Searching-in-a-table/m-p/217850#M71024 <HTML><HEAD></HEAD><BODY><P>Hi community,</P><P>Please i have a serious problem.</P><P>I have an EXCEL file. You can see it in attached file.</P><P>I have loaded this file in a qlikview table by this statement :</P><P style="font-weight: bold">Tableau_De_Bord:<BR />LOAD ID,<BR /> Label,<BR /> [Solde d'ouverture],<BR /> [Reelles YTD],<BR /> [Budget YTD],<BR /> [Prévisions YTD]<BR />FROM<BR />[STAR\EXCEL files\Tableau de bords.xls]<BR />(biff, embedded labels, table is Feuille1$);</P><P>The field <B>[Reelles YTD]</B> contains the formula.</P><P>I want to obtain these formula using the value of <B>ID</B> field.</P><P>Please, it is very urgent.</P><P>Thanks.</P></BODY></HTML> Wed, 08 Dec 2010 17:55:07 GMT https://community.qlik.com/t5/QlikView/Searching-in-a-table/m-p/217850#M71024 2010-12-08T17:55:07Z Searching in a table https://community.qlik.com/t5/QlikView/Searching-in-a-table/m-p/217851#M71025 <HTML><HEAD></HEAD><BODY><P>To use a formula from an external source use the $(formula_field)</P><P>Also noticed you need to remove the space after the =</P><P>= Sum</P><P>=Sum</P></BODY></HTML> Thu, 09 Dec 2010 01:35:06 GMT https://community.qlik.com/t5/QlikView/Searching-in-a-table/m-p/217851#M71025 2010-12-09T01:35:06Z