topic Re: if formula in script in QlikView

if formula in script

carolin01 — Tue, 13 Jan 2015 14:21:24 GMT

Hi,

I Need some quick help. It´s stupid but I can just not see my error in my formula here:

if(Status = 3,
if(floor(ConfirmedReceiptDate = '01.01.1800',((floor(ReceiptDate2)) - (floor(PlannedReceiptDate)),
((floor(ReceiptDate2)) - (floor(ConfirmedReceiptDate))))))) as OnTimeDeliveryInDays,

Staring at this for a lot of time now I´m sure it´s quicker to get some help from somebody here 🙂

Best regards

Carolin

Re: if formula in script

marcus_malinow — Tue, 13 Jan 2015 14:32:15 GMT

Hi Carolin,

try this:

if(Status = 3,
if(floor(ConfirmedReceiptDate) = '01.01.1800',(floor(ReceiptDate2)) - (floor(PlannedReceiptDate)),
((floor(ReceiptDate2)) - (floor(ConfirmedReceiptDate))))) as OnTimeDeliveryInDays,

Marcus

Re: if formula in script

alexandros17 — Tue, 13 Jan 2015 14:33:42 GMT

Try this

=if(Status = 3,
if(floor(ConfirmedReceiptDate) = '01.01.1800',floor(ReceiptDate2) - floor(PlannedReceiptDate),
floor(ReceiptDate2) - floor(ConfirmedReceiptDate)
)
) as OnTimeDeliveryInDays,

Re: if formula in script

marcus_sommer — Tue, 13 Jan 2015 14:34:04 GMT

Here is a missing bracket behind the date-field:

floor(ConfirmedReceiptDate = '01.01.1800'

Also there are too many unnecessary brackets around floor and the subtraction - this is only confusing.

- Marcus

Re: if formula in script

carolin01 — Tue, 13 Jan 2015 14:36:23 GMT

Thank you, this was perfect for copy and paste 🙂 I knew it had to do with the brackets but I couldn´t see it anymore...

Re: if formula in script

its_anandrjs — Tue, 13 Jan 2015 14:37:42 GMT

Hi,

Try this expression

if(Status = 3
And
floor(ConfirmedReceiptDate) = '01.01.1800',

(floor(ReceiptDate2) - floor(PlannedReceiptDate)),
(floor(ReceiptDate2) - floor(ConfirmedReceiptDate))) as OnTimeDeliveryInDays

if(Status = 3,
if(floor(ConfirmedReceiptDate) = '01.01.1800',

(floor(ReceiptDate2) - floor(PlannedReceiptDate)),
(floor(ReceiptDate2) - floor(ConfirmedReceiptDate)))) as OnTimeDeliveryInDays

Regards

Anand

Re: if formula in script

reshmakala — Tue, 13 Jan 2015 14:38:40 GMT

Try this:

if(Status = 3,

if(floor(ConfirmedReceiptDate) = '01.01.1800',floor(ReceiptDate2) - floor(PlannedReceiptDate),

(floor(ReceiptDate2) - floor(ConfirmedReceiptDate)))) as OnTimeDeliveryInDays