https://community.qlik.com/t5/QlikView/Convert-an-expression-into-script/m-p/1707950#M724704 <P>Dears,</P><P>How can I convert the following expressions into a script?</P><LI-CODE lang="markup">= LINEST_M(Aggr(avg( If(DVPG &gt; '18/03/2020', VDAF) ), STCK, DVPG ), DVPG )</LI-CODE><LI-CODE lang="markup">=LINEST_R2(Aggr(avg(DISTINCT If(DVPG &gt; '18/03/2020', VDAF)), STCK, DVPG),DVPG)</LI-CODE><P>&nbsp;</P><P>The fields can be obtained from the following tables:<BR /><BR />VDAF and STCK =&gt; Table Empresas<BR />STCK and DVPG =&gt; Table Cotações<BR /><BR /></P><P>DVPG has the same content as the Field PERI, that can also be found at Table Empresas</P><P>&nbsp;</P><P>How can I do that?<BR />Thanks</P> Wed, 25 Nov 2020 16:16:04 GMT brunolelli87 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Convert-an-expression-into-script/m-p/1707950#M724704 <P>Dears,</P><P>How can I convert the following expressions into a script?</P><LI-CODE lang="markup">= LINEST_M(Aggr(avg( If(DVPG &gt; '18/03/2020', VDAF) ), STCK, DVPG ), DVPG )</LI-CODE><LI-CODE lang="markup">=LINEST_R2(Aggr(avg(DISTINCT If(DVPG &gt; '18/03/2020', VDAF)), STCK, DVPG),DVPG)</LI-CODE><P>&nbsp;</P><P>The fields can be obtained from the following tables:<BR /><BR />VDAF and STCK =&gt; Table Empresas<BR />STCK and DVPG =&gt; Table Cotações<BR /><BR /></P><P>DVPG has the same content as the Field PERI, that can also be found at Table Empresas</P><P>&nbsp;</P><P>How can I do that?<BR />Thanks</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Convert-an-expression-into-script/m-p/1707950#M724704 brunolelli87 2020-11-25T16:16:04Z