Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Linest_M, calculating the slope

Hi all,

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:

2 Questions:

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!

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Linest_M, calculating the slope

sum is obsolete in the Linest_M statement

1 Reply
Not applicable

Re: Linest_M, calculating the slope

sum is obsolete in the Linest_M statement

Community Browser