Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Not applicable

How to analyse next month orders

Hi ,All

data base table consists company Id ,month wise orders.

how can i analyse  next month Orders by using last last six month data.

That mean how many orders can i except next month based on company wise

Thanks

ramu.

Tags (1)
11 Replies
Highlighted
rgvavihs
Valued Contributor

Re: How to analyse next month orders

Hi

Can you please explain more what you need ?

Highlighted
parthakk
Contributor II

Re: How to analyse next month orders

Hi,

I guess you are asking about forecast. For this first you add previous months sum sales. And then u divide it by max month value. i.e sum(Sales)/ MaxMonth. Then you assign that value to future months..

For you the forecast values is 600.

Hope this is what you expected.

Thanks,

Partha K

Highlighted
Not applicable

Re: How to analyse next month orders

Thank you,

Highlighted
gautik92
Valued Contributor III

Re: How to analyse next month orders

have a look at this

Highlighted
vikasmahajan
Esteemed Contributor

Re: How to analyse next month orders

You can achieve the same using What if analysis search it

Vikas

Highlighted
Not applicable

Re: How to analyse next month orders

I am using Qlikview trail version , could you please send set analysis expression

Highlighted
gautik92
Valued Contributor III

Re: How to analyse next month orders

Actual:

LOAD SalesPerson,

  Sales,

  Date#(YearMonth, 'YYYYMM') as YearMonth

Inline [

SalesPerson, Sales, YearMonth

A, 40, 201507

A, 30, 201507

A, 40, 201508

A, 20, 201508

A, 50, 201508

B, 60, 201507

B, 90, 201508

B, 20, 201508

B, 10, 201508

];

Target:

LOAD SalesPerson,

  SalesTarget,

  Date#(YearMonth, 'YYYYMM') as YearMonth

Inline [

SalesPerson, SalesTarget, YearMonth

A, 50, 201507

A, 115, 201508

B, 50, 201507

B, 115, 201508

];

MaxDate:

LOAD Max(YearMonth) as MaxYearMonth

Resident Actual;

LET vMaxYearMonth = Peek('MaxYearMonth');

DROP Table MaxDate;

TempTable:

LOAD SalesPerson,

  Sum(Sales) as TotalSales

Resident Actual

Where YearMonth = $(vMaxYearMonth)

Group By SalesPerson;

Join(TempTable)

LOAD SalesPerson,

  SalesTarget

Resident Target

Where YearMonth = $(vMaxYearMonth);

Concatenate(Target)

LOAD SalesPerson,

  If(TotalSales >= SalesTarget, SalesTarget, SalesTarget * (1.10)) as SalesTarget,

  Date(AddMonths($(vMaxYearMonth), 1), 'YYYYMM') as YearMonth

Resident TempTable;

DROP Table TempTable;

Highlighted
Not applicable

Re: How to analyse next month orders

Thank you

Highlighted
gautik92
Valued Contributor III

Re: How to analyse next month orders

if you got the answer mark correct and helpful answer and close the thread