Trend

[marikabi]

Hello Everyone,

I'm new on Qlik View.

I have uploaded a file excel with these columns:

REGION, STORE, QUANTITY SOLD.

The excel file is made of 13 different sheets: CURRENT MONTH, MONTH-1 -- MONTH-12.

What I need to do is to determine if the sales are growing or not and how fast for every REGION.

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:

I mean, it works for the stores, but in every region there are more stores.

I think I have to modify the script, but to be honest I'm not able to do it.

Could you please kindly help me?

Thanks in advance