Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

demaina1995
New Contributor II

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 ?

Could you please help me ?

Best regards,

6 Replies
gerry_hdm
Contributor II

Re: calculate WIP by comparing dates

what is the Output ?

omarbensalem
Esteemed Contributor

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...

Interval Match or Inline load

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

Forget about IntervalMatch

Regards,

Regards,
Prashant Sangle
demaina1995
New Contributor II

Re: calculate WIP by comparing dates

graph.PNG

I would like something like that as an input

zebhashmi
Valued Contributor

Re: calculate WIP by comparing dates

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

Thank you

demaina1995
New Contributor II

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