Trial and error method?

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I got requirement like below,

Let's say online Customer ordered 14 piece of ladies bag to xx shoes company and that xx company have two size of box cartoon like,

1) Box cartoon : 4 piece (maximum capacity) --> assume as A value

2) Box Cartoon box : 6 piece (maximum capacity --> assume as B value

and we assume Customer ordered Piece 14 as C

How to find X & Y value?

XA+YB=C

1) Example,

4X+6Y=14 (if we consider X is 2 and Y is 1 then it should tie with C, how to solve above equation ? need to find x & y automatically

2) Example

what if i give you A=922 and B=532 and C=1000000

need to be able to find if x and y even exists without using method if exhaustion of meaning trial and error?

Note: Given X and Y is whole number and positive values

What i've tried is below,

i figured out till c-xa has to be divisible by b. which leads to sum of c mod b and -xa mod c has to be divisible by b then i'm stucked on how to fine the set of x other than exhaustion.

is there anyway to prove above expression using qlikview? or other logic. kindly provide your valuable suggestions. Many Thanks and happy weekend.

Regards,Dev

Re: Trial and error method?

vinieme12 — Mon, 17 Apr 2017 13:17:08 GMT

Hi Dev,

This is a linear programming problem, I suggest you ask this on a Quants / Math forum.

Or use "Solver" Add-in in Excel, if you know how to..

topic Trial and error method? in QlikView

Trial and error method?

Re: Trial and error method?