Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
Can you please explain more what you need ?
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
Thank you,
have a look at this
You can achieve the same using What if analysis search it
Vikas
I am using Qlikview trail version , could you please send set analysis expression
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;
Thank you
if you got the answer mark correct and helpful answer and close the thread