Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
Creator II
Creator II

Adapt my expression to Script

Hello guys,

How can I adapt the following 2 expressions to run on Script?
It's taking too much time to recalculate on every chart changing, and would be much better to have it load with script.

= LINEST_M(Aggr(avg( If(DVPG > '18/03/2020', VDAF) ), STCK, DVPG ), DVPG )
=LINEST_R2(Aggr(avg(DISTINCT If(DVPG > '18/03/2020', VDAF)), STCK, DVPG),DVPG)

 

This is the chart where the expression can be found - The dimension is STCK:

2.png

 

Please, find below my project with a Sample Data.
Thanks

0 Replies