topic Re: Back Order Calculation in QlikView

Back Order Calculation

Tue, 15 Jan 2013 09:02:14 GMT

Dear All,

I have issue with calculation of Back orders.

Actually we have data as some backorders are generated and some released in particular date time , So remaining back orders are to be carry forward for next date time interval.

But this functionality I am unable to implement.

Kindly suggest if anyone have some solution for it.

Example\

YearMonth BO_generated BO_released

201211 10 5

201212 15 12

201301 5 6

Calculation should be >>

201211 10 5 5

201212 15 12 3+5=8

201301 5 6 -1+8=7

Thanks & Regards

Nitin Gupta

YMSLI

8802744818

Re: Back Order Calculation

Anonymous — Tue, 15 Jan 2013 09:04:41 GMT

Does this post help ? http://community.qlik.com/message/299811#299811

Jonathan

Re: Back Order Calculation

sujeetsingh — Tue, 15 Jan 2013 09:16:33 GMT

Hi ,

jonathan had given a clear picture and solution...

use above function

Re: Back Order Calculation

Thu, 24 Jan 2013 10:58:54 GMT

Hello,

I think I was unable to explain my problem in a correct way.

I am attaching an example .

Here there are 4 expressions as pre bo, fixed do, delivery, actual bo

Actually prebo is bo generated previously of selected year month.

and actual bo is fixed do-delivery+prebo.

This actual bo will act as prebo for another day.

I was actually busy in some other project, but now situations have become critical for me.

If please provide me some suggestion how to achieve this concept.