topic Re: Script in QlikView

Script

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

IAM writing below condition in the edit script just wanted to know if this is correct

The requirement is like consider dispatch date should be

Publish_date is not empty and selling_date is empty to achieve this IAM writing below script

If(isnull(selling_date),publish_date) as dispatch_Date

Thanks in advance

Re: Script

Chanty4u — Thu, 29 Mar 2018 05:37:09 GMT

try this

If(IsNull(TRIM(Selling_date)) = -1, 1,Publish_date) as Dispatchdate

Re: Script

PrashantSangle — Thu, 29 Mar 2018 06:11:10 GMT

Not understood clearly.

1: Do you want to consider dispatch_date when publish_date is not empty and selling_date is empty as dispatch_date

then

if(isnull(selling_Date) and not isnull(publish_date),dispatch_date) as dispatch_date

2: Do you want to create new field as dispatch_date when publish_date is not empty then publish_date else selling_date as dispatch_Date

then

if(isnull(selling_date),publish_date,selling_date) as dispatch_date

Regards

Re: Script

jonathandienst — Thu, 29 Mar 2018 06:14:24 GMT

Do you mean: Use selling date if selling date is not null; use publish date if selling date is null? Then

Alt(selling_date, publish_date) as dispatch_Date

Date(Alt(selling_date, publish_date)) as dispatch_Date

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFunctions/alt.htm

Re: Script

smilingjohn — Thu, 29 Mar 2018 06:16:08 GMT

Hi Prashant

Hi want to create a field called dispatch_date

Which should consist the below condition and that is

Consider publish_date is not empty but selling_date emtpy ..

Thanks

Re: Script

smilingjohn — Thu, 29 Mar 2018 06:20:39 GMT

Hi Jonathan

I want to achieve below described scenario

create a field called dispatch_date

Which should consist the below condition and that is

Consider publish_date is not empty but selling_date emtpy ..

Thanks

Re: Script

jonathandienst — Thu, 29 Mar 2018 06:23:05 GMT

>>Consider publish_date is not empty but selling_date emtpy ..

Not sure what that means. Is this not what I described in my earlier post?

Re: Script

PrashantSangle — Thu, 29 Mar 2018 06:30:40 GMT

ok then give can you ans below query to help you better way

1 : If your said condition is true, then which field you want to show as dispatch_date?

2: if not true, then which field you want to show as dispatch_date?

If possible explain with simple example.

Regards,

Re: Script

sasiparupudi1 — Thu, 29 Mar 2018 07:48:24 GMT

IF( Len(publish_date)>0 and Len(Trim(selling_date))=0,publish_date) as dispatch_Date

Re: Script

Anonymous — Thu, 29 Mar 2018 09:34:27 GMT

Hi John - Use the below code

If(Not isnull(Publish_date) and Len(Selling_Date) = 0, Publish_date) as Dispatch_Date

Thanks,

Venkata Sreekanth