Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
Creator II
Creator II

Convert an expression into script

Dears,

How can I convert the following expressions into a 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)

 

The fields can be obtained from the following tables:

VDAF and STCK => Table Empresas
STCK and DVPG => Table Cotações

DVPG has the same content as the Field PERI, that can also be found at Table Empresas

 

How can I do that?
Thanks

0 Replies