Discussion Board for collaboration on QlikView Scripting.
I need to calculate the slope of the trend per product/Department for 5 months in my script.
This wil be used later on in a dashboard to indicate if formentioned combination has a positive or negative trend.
The script I've thusfar is:
1. is it necessary to generate all combinations of Product/department/Dates with Amnt = 0 when they do not exist
2. Will the coding be appropriate in order to calculate the correct slope for the combinations...
thx in advance!
Go to Solution.
sum is obsolete in the Linest_M statement