Qlikview scripting logic

[sakshikaul]

Hi,

I have attached the following QVW.

I want to maintain a status by writing expression in list box 

status :-

1. if time of receipt field is having any value (means any date) then status should be as RECEIVED

2) if time of receipt field is having no value (means no date) and > =due date@wprc then status should be as PNR

3) if time of receipt field is having no value (means no date) and <= due date@wprc then status should be as WAITING

4) cancelled after PNR  5)cancelled after checking 6) parts accepted ---> these all status should be updated by using excel ie the user will maintain all these status(4,5,6) in excel so by using apply map function we can change the status 

so how to implement all the above status ?

[sakshikaul]

1)I want when reception date is present then status should be maintained as Received

2) If reception date has no data but packing slip date is between packing slip date and Due date@ Wprc then status should be waiting 

3) If reception date has no date but packing slip date is > due date @ Wprc then status should be PNR 

4) Accepted status will be maintained for other than above threee status 

Please refer Qvw attached

Please help. Its required urgently

@Vegar  can you help Please????