Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Computing Linest_M

Hello,

Attached is my solution for calculating the trend (slope) of business departments' sales revenue over a 6 months window.  I like you to review my expression to make sure that (1) it is written correctly for the intent and (2) if there is a more efficient or more straight forward way of forming the aggregation / calculation. Thank you.

The data dimensions are as follow:

Business Unit = department

Client Number and Sub Analysis = customer and product

RevenueDate = sales date

#RevenueUSD = sales amount

The task is to calculate the revenue trend of each business unit over the set period.

Tags (1)
1 Reply
ecolomer
Honored Contributor II

Re: Computing Linest_M

It's correct for me.

Community Browser