topic Re: Show Potential Finish Time in QlikView

Show Potential Finish Time

rustyfishbones — Fri, 28 Feb 2014 12:52:45 GMT

Hi All,

I have the following Doughnut Chart that shows cases picked versus total.

What I want to do next is to show the potential finish time based on Current Average and Potential finish time if I add more people to a task.

I have the following variables

input.volume.picking = 20,000

input.picking.ops = 0

I have the following Expression to look at what has been picked so far today, which is then divided by the $(input.volume.picking) to get % complete

So I want to get average cases picked per hour and then what that average would be if I added more pickers. Just wondering where to start with this?

Maybe something like this? but i need a new End Time

Amount / Start Time - End Time /Current Ops* $(input.picking.ops)

Struggling!!

Alan

Re: Show Potential Finish Time

MK_QSL — Fri, 28 Feb 2014 13:21:05 GMT

Little understand from your question.

Could you provide at least one example with result so that we can help you by understanding your logic more clearly.

Re: Show Potential Finish Time

jonathandienst — Fri, 28 Feb 2014 13:40:07 GMT

To calculate a potential completion time, you need the following:

Actual start time
Target amount (input.volume.picking)
Elapsed time (you don't mention this one) or curent time of measurement
Amount picked at elapsed time

Then:

Actual pick rate = amount picked / elapsed time
OR = amount picked / (time of measurement - start time)
What-If pick rate = actual pick rate * input.picking.ops (which should be a value of 1 by default)

And

Time to completion = target amount / actual pick rate
What-If time to completion = target amount / what-if pick rate
End time = start time + Time to completion
What-if end time = start time + what-if time to completion

HTH

Jonathan

Re: Show Potential Finish Time

rustyfishbones — Fri, 28 Feb 2014 15:21:09 GMT

Here is what I have

Obvoiusly I have expressions behind all of these and they are correct.

Right now I can deal with getting average times

So it would be

Cases Due - Cases Picked = 7,108/Average Cases per Hour = 1750

The result is 4.06, Can I just add this to the Max PickTime of 09:30:50?

Here is the Expression I have to do this, but the result is not correct

I am hoping to for a Finish Time of 13:30

However the result being returned is 61683.028078705

Re: Re: Show Potential Finish Time

rustyfishbones — Fri, 28 Feb 2014 15:39:17 GMT

Hi All,

I have attached a reduced version of the file

Re: Show Potential Finish Time

rustyfishbones — Fri, 28 Feb 2014 15:59:39 GMT

Any ideas with this?

Re: Show Potential Finish Time

rustyfishbones — Fri, 28 Feb 2014 16:12:37 GMT

Hi Manish,

Any chance you could take a look at this?

Apologies for being annoying, just trying to get this sorted before the weekend

Thanks

Alan

Re: Re: Re: Show Potential Finish Time

Gysbert_Wassenaar — Fri, 28 Feb 2014 18:03:38 GMT

The variable input.volume.picking was set to value 50000 instead of 20000.

EndTime is a date. If you add 1 to it you get the next day. If you add 4.06 to it you get a datetime that's 4 days and a bit later. So you need to divide the 4.06 by 24 first since 4.06 is supposed to be a number of hours, not days. Finally you want the end result formatted as a time, not just the EndTime. Try this instead:

=TIME(($(input.volume.picking)
- 
SUM({<Date = {"$(=MAX(Date))"},[Trx Type] ={'D'},ActionId ={'PICKCASE'}>}Primary))
/
NUM((SUM({<Date = {"$(=MAX(Date))"},[Trx Type] ={'D'},ActionId ={'PICKCASE'}>}Primary)
/SUM({<Date = {"$(=MAX(Date))"},ActionId ={'PICKCASE'},[Trx Type] = {'D'}>}NewPickTime)),'#,##0')/24
+
MAX({$<Date = {"$(=MAX(Date))"},[Trx Type] = {'D'},ActionId = {'PICKCASE'}>}EndTime))

Re: Show Potential Finish Time

rustyfishbones — Fri, 28 Feb 2014 19:59:49 GMT

Excellent, this works

I was not far away, I did not format the time and I was not dividing by 24 to get the hours

How long are you using Qlikview? you have all the answers

Thanks so much Gysbert

Kind Regards

Alan

Re: Show Potential Finish Time

rustyfishbones — Fri, 28 Feb 2014 20:29:30 GMT

Hi Gysbert,

One final question, I swear.

If I want the End Time to change based on the number of guys I add to a task, for example if I have 4 current pickers and change to 5 using the $(input.picking.ops).

My question is how do I get the current Pickers, would it be something like if they have picked in the last 2 minutes to get the current pickers?

Not sure how to get this.

Time functions cause me problems for some reason!!

Thanks again

Alan