topic Re: How to analyse next month orders in QlikView

How to analyse next month orders

Mon, 28 Sep 2015 05:23:41 GMT

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.

Re: How to analyse next month orders

Anonymous — Mon, 28 Sep 2015 05:29:25 GMT

Can you please explain more what you need ?

Re: How to analyse next month orders

parthakk — Mon, 28 Sep 2015 05:38:20 GMT

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

Re: How to analyse next month orders

Mon, 28 Sep 2015 05:44:19 GMT

Thank you,

parthakk

Re: How to analyse next month orders

gautik92 — Mon, 28 Sep 2015 05:51:50 GMT

have a look at this

Re: How to analyse next month orders

vikasmahajan — Mon, 28 Sep 2015 05:52:26 GMT

You can achieve the same using What if analysis search it

Vikas

Re: How to analyse next month orders

Mon, 28 Sep 2015 05:58:37 GMT

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

Re: How to analyse next month orders

gautik92 — Mon, 28 Sep 2015 05:59:41 GMT

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;

Re: How to analyse next month orders

Mon, 28 Sep 2015 06:02:17 GMT

Thank you

gautik92

Re: How to analyse next month orders

gautik92 — Mon, 28 Sep 2015 06:14:29 GMT

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

Re: How to analyse next month orders

Mon, 28 Sep 2015 07:07:25 GMT

Could you please explain detail about forecasting

Re: How to analyse next month orders

pratap6699 — Mon, 28 Sep 2015 10:06:51 GMT

in your sample table contains order id with 6 months sales, if you select jan month chart display july to december sales......suppose select july it shows jan to june sales right? then go to this expression on chart-->

sum({<month={">=$(=min(month))<=$(=min(month)-6)"}>}sales)