topic Trend in QlikView https://community.qlik.com/t5/QlikView/Trend/m-p/1140082#M900354 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P>I'm new on Qlik View.</P><P></P><P>I have uploaded a file excel with these columns:</P><P>REGION, STORE, QUANTITY SOLD.</P><P>The excel file is made of 13 different sheets: CURRENT MONTH, MONTH-1 -- MONTH-12.</P><P></P><P>What I need to do is to determine if the sales are growing or not and how fast for every REGION.</P><P>I'm trying to do it using a pivot and the LINEST_M function, but I'm not able to group the sales for region:</P><P>I mean, it works for the stores, but in every region there are more stores.</P><P></P><P>I think I have to modify the script, but to be honest I'm not able to do it.</P><P>Could you please kindly help me?</P><P>Thanks in advance <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT marikabi 2020-11-25T16:16:04Z Trend https://community.qlik.com/t5/QlikView/Trend/m-p/1140082#M900354 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P>I'm new on Qlik View.</P><P></P><P>I have uploaded a file excel with these columns:</P><P>REGION, STORE, QUANTITY SOLD.</P><P>The excel file is made of 13 different sheets: CURRENT MONTH, MONTH-1 -- MONTH-12.</P><P></P><P>What I need to do is to determine if the sales are growing or not and how fast for every REGION.</P><P>I'm trying to do it using a pivot and the LINEST_M function, but I'm not able to group the sales for region:</P><P>I mean, it works for the stores, but in every region there are more stores.</P><P></P><P>I think I have to modify the script, but to be honest I'm not able to do it.</P><P>Could you please kindly help me?</P><P>Thanks in advance <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Trend/m-p/1140082#M900354 marikabi 2020-11-25T16:16:04Z