https://community.qlik.com/t5/App-Development/Gradient-Calculation-on-a-Time-Series-Data/m-p/1902760#M74461 <P>Hello fellow Qlikers,</P> <P>I need to bring the excel slope function calculation to Qlik's App for a table I am making.</P> <P>I want to calculate the slope based on values of previous five days, where KNOWN-Ys are "DAILY_STOCK_RETURNS", while KNOWN-Xs are "MARKET_RETURNS". Please note that both the fields are calculated measures in Qlik.</P> <P>The problem I'm facing is that the LINEST_M function is an aggregate function and hence can't be applied to each row, as is my requirement.</P> <P>The table in excel (attached) has the following headers and shows slope function applied under "BETA" column:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="junaid_hanif_1-1646808863626.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74018iB048E51F150C5339/image-size/medium?v=v2&amp;px=400" role="button" title="junaid_hanif_1-1646808863626.png" alt="junaid_hanif_1-1646808863626.png" /></span></P> <P>&nbsp;</P> <P>Could anyone please help me replicate this formula in Qlik.</P> Wed, 09 Mar 2022 07:02:59 GMT junaid_hanif 2022-03-09T07:02:59Z https://community.qlik.com/t5/App-Development/Gradient-Calculation-on-a-Time-Series-Data/m-p/1902760#M74461 <P>Hello fellow Qlikers,</P> <P>I need to bring the excel slope function calculation to Qlik's App for a table I am making.</P> <P>I want to calculate the slope based on values of previous five days, where KNOWN-Ys are "DAILY_STOCK_RETURNS", while KNOWN-Xs are "MARKET_RETURNS". Please note that both the fields are calculated measures in Qlik.</P> <P>The problem I'm facing is that the LINEST_M function is an aggregate function and hence can't be applied to each row, as is my requirement.</P> <P>The table in excel (attached) has the following headers and shows slope function applied under "BETA" column:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="junaid_hanif_1-1646808863626.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74018iB048E51F150C5339/image-size/medium?v=v2&amp;px=400" role="button" title="junaid_hanif_1-1646808863626.png" alt="junaid_hanif_1-1646808863626.png" /></span></P> <P>&nbsp;</P> <P>Could anyone please help me replicate this formula in Qlik.</P> Wed, 09 Mar 2022 07:02:59 GMT https://community.qlik.com/t5/App-Development/Gradient-Calculation-on-a-Time-Series-Data/m-p/1902760#M74461 junaid_hanif 2022-03-09T07:02:59Z