https://community.qlik.com/t5/QlikView/Adapt-my-expression-to-Script/m-p/1708636#M724095 <P>Hello guys,</P><P>How can I adapt the following 2 expressions to run on Script?<BR />It's taking too much time to recalculate on every chart changing, and would be much better to have it load with 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>This is the chart where the expression can be found - The dimension is STCK:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.png" style="width: 606px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/35046i0E48440C7237AB9B/image-size/large?v=v2&amp;px=999" role="button" title="2.png" alt="2.png" /></span></P><P>&nbsp;</P><P>Please, find below my project with a Sample Data.<BR />Thanks</P> Wed, 25 Nov 2020 16:16:04 GMT brunolelli87 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Adapt-my-expression-to-Script/m-p/1708636#M724095 <P>Hello guys,</P><P>How can I adapt the following 2 expressions to run on Script?<BR />It's taking too much time to recalculate on every chart changing, and would be much better to have it load with 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>This is the chart where the expression can be found - The dimension is STCK:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.png" style="width: 606px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/35046i0E48440C7237AB9B/image-size/large?v=v2&amp;px=999" role="button" title="2.png" alt="2.png" /></span></P><P>&nbsp;</P><P>Please, find below my project with a Sample Data.<BR />Thanks</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Adapt-my-expression-to-Script/m-p/1708636#M724095 brunolelli87 2020-11-25T16:16:04Z