topic Re: Linest_M not working in QlikView https://community.qlik.com/t5/QlikView/Linest-M-not-working/m-p/418436#M488614 <HTML><HEAD></HEAD><BODY><P>Your %KwartaalJahr is non-numeric.</P></BODY></HTML> Fri, 07 Dec 2012 17:55:57 GMT swuehl 2012-12-07T17:55:57Z Linest_M not working https://community.qlik.com/t5/QlikView/Linest-M-not-working/m-p/418435#M488613 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a very easy data model and I like to calculate the LINEST_M value (Trend line)</P><P>I have a field that represents a Year_Quarter = [%KwartaalJaar], a category = [ProjectPrestatie_Onderzoeksveld] and a value field = [PP_Cijfer]</P><P></P><P>I like to calculate the LINEST_M for the Categories over the Quarters, I use the following expression:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; LINEST_M( AGGR(AVG(PP_Cijfer), %KwartaalJaar),%KwartaalJaar)</P><P></P><P>But I don't get a value, what am I doing wrong??</P><P></P><P>See attached document</P><P></P><P>Thanks in advance!</P><P>Frank</P></BODY></HTML> Fri, 07 Dec 2012 17:48:14 GMT https://community.qlik.com/t5/QlikView/Linest-M-not-working/m-p/418435#M488613 beunderf 2012-12-07T17:48:14Z Re: Linest_M not working https://community.qlik.com/t5/QlikView/Linest-M-not-working/m-p/418436#M488614 <HTML><HEAD></HEAD><BODY><P>Your %KwartaalJahr is non-numeric.</P></BODY></HTML> Fri, 07 Dec 2012 17:55:57 GMT https://community.qlik.com/t5/QlikView/Linest-M-not-working/m-p/418436#M488614 swuehl 2012-12-07T17:55:57Z Re: Linest_M not working https://community.qlik.com/t5/QlikView/Linest-M-not-working/m-p/418437#M488615 <HTML><HEAD></HEAD><BODY><P>Thank you verry much!! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Fri, 07 Dec 2012 18:04:56 GMT https://community.qlik.com/t5/QlikView/Linest-M-not-working/m-p/418437#M488615 beunderf 2012-12-07T18:04:56Z