Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Creator II
Creator II

what is the Output ?

OmarBenSalem

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

PrashantSangle

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

graph.PNG

I would like something like that as an input

zebhashmi
Specialist
Specialist

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

Thank you

Anonymous
Not applicable
Author

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