Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

11 Replies
Anonymous
Not applicable
Author

Hi

Can you please explain more what you need ?

parthakk
Creator II
Creator II

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

Not applicable
Author

Thank you,

gautik92
Specialist III
Specialist III

have a look at this

vikasmahajan

You can achieve the same using What if analysis search it

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

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

gautik92
Specialist III
Specialist III

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;

Not applicable
Author

Thank you

gautik92
Specialist III
Specialist III

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