topic Re: Qlikview scripting logic in QlikView

Qlikview scripting logic

sakshikaul — Sun, 15 Mar 2020 08:46:48 GMT

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 ?

Re: Qlikview scripting logic

sakshikaul — Sun, 15 Mar 2020 14:30:49 GMT

I have tried to implement 1,2,3 point but not getting correct answer. Where I am going wrong?and also how to implement 4,5,6 status?

@sunny_talwar please help

=if(len(trim([TIME OF RECEIPT]))=10 ,'RECEIVED',if(len(trim([TIME OF RECEIPT]))=0 AND [Due Date @ wprc]>=[Due Date @ wprc],'PNR',if(len(trim([TIME OF RECEIPT]))=0 AND [Due Date @ wprc]<=[Due Date @ wprc],'PART WAITING')))

Re: Qlikview scripting logic

sunny_talwar — Mon, 16 Mar 2020 10:59:10 GMT

The attached sample is without any data... can you please post a sample where we can see some data

Re: Qlikview scripting logic

sakshikaul — Mon, 16 Mar 2020 11:38:24 GMT

Re: Qlikview scripting logic

sakshikaul — Mon, 16 Mar 2020 11:39:57 GMT

It is having sample data

Re: Qlikview scripting logic

sunny_talwar — Mon, 16 Mar 2020 11:48:02 GMT

When I open you attached app, I see not data at all... look at table viewer in the attached image

Re: Qlikview scripting logic

sakshikaul — Fri, 27 Mar 2020 08:16:20 GMT

Re: Qlikview scripting logic

Brett_Bleess — Wed, 08 Apr 2020 18:32:15 GMT

@sunny_talwar latest app above has data, I checked, so should be able to move forward if you have some time to have a look.

Cheers,
Brett

Re: Qlikview scripting logic

sunny_talwar — Wed, 08 Apr 2020 19:14:20 GMT

thanks @Brett_Bleess. Not sure how I missed this.

@sakshikaul what are you comparing due_date to when Time of Receipt is null in 2 and 3?

Re: Qlikview scripting logic

sakshikaul — Thu, 09 Apr 2020 14:48:53 GMT

I am trying to implement the logic.....let me try and will update on this.

Re: Qlikview scripting logic

sakshikaul — Wed, 06 May 2020 14:32:35 GMT

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