6 Replies Latest reply: Mar 15, 2018 4:45 AM by Caroline Huet

# calculate WIP by comparing dates

Hello,

I would like to calculate the Work in Progress for my products so I would need to compare dates.

My table is :

IDDateDate type
110/03/2018beginning
212/03/2018beginning
313/03/2018beginning
115/03/2018end
218/03/2018end
320/03/2018end

I would like to draw a line chart showing the number of product that are between the beginning and the end date in function of generic dates. So I will have the number of product in the production line in function of dates.

Do you think I have to rearrane my table to do that ?

Best regards,

• ###### Re: calculate WIP by comparing dates

what is the Output ?

• ###### Re: calculate WIP by comparing dates

I would like something like that as an input

• ###### Re: calculate WIP by comparing dates

You'll have to use intervalMatch in the script to build this:

Please try to refer to this to understand the intervalMatch function :

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/IntervalMatch.htm

IntervalMatch

QlikView IntervalMatch

• ###### Re: calculate WIP by comparing dates

Hi,

as omarbensalem suggest you have to generate missing date i.e date between beginning date & end date,

but instead of using interval match use logic mention in below thread.

It will very effective compare to interval match

Regards,

• ###### Re: calculate WIP by comparing dates

Can you explain a little bit more, what are you looking for?

Thank you

• ###### Re: calculate WIP by comparing dates

My data :

ID productbeginning dateend date
101/01/201801/02/2018
201/01/201801/03/2018
301/02/201801/03/2018
401/03/201801/04/2018

I would like to be able to have the following table :

DateNumber of products in progress
January 20185
February 201810
March 20188
April 20187

Number of products counts the number of product with beginningDate < current date < end date