Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arianaford
New Contributor II

Over Due Dates

So my data currently comes in with a date, this is the date that the complaint is recieved

11/12/15

24hrs from this date there is a deadline that must be met, if it is met in the 3D COMPLETE feild there will be a date so for example

11/13/15

then , each customer has their own amount of time from the original complaint date  say this customer has 15 days, so D5 must be complete by

11/27/15

If we are past this date it needs to show overdue, and if possible how many days overdue, then if that is completed within its window it moves onto d8 and for d8 it has to be complted within 30 days of the original complaint date,

so 12/12/2015

if that is not completed within that time, it must say overdue.

Is there a way that I can code this into my load script, or into a master item? I would love some help with this!

I have created some look up tables in the case that I need them, I also have attatched a sample of my data.

Thanks

Ariana