Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to make an expression with multiple 'if' functions:
If('order_status' = 'A' and 'Confirm_date'-'Create_date'>1, 'Quantity',0) as Late_quantity,
however, another kind of orders should be also categorised as late orders:
If('order_status' = 'B' and 'Confirm_date' is null and Today()-'Create_date'>1,'Quantity',0) as Late_quantity.
Is it possible to make an expression in Qlikview to cover both cases into one scenario?
Hi Peter,
try this
=If('order_status' = 'A' and 'Confirm_date'-'Create_date'>1, 'Quantity',
If('order_status' = 'B' and 'Confirm_date' is null and Today()-'Create_date'>1,'Quantity',0)) as Late_quantity
Regards,
Jagan.
Try This
If('order_status' = 'A' and 'Confirm_date'-'Create_date'>1, 'Quantity',
If('order_status' = 'B' and 'Confirm_date' is null and Today()-'Create_date'>1,'Quantity') as Late_quantity.
Hi Peter,
try this
=If('order_status' = 'A' and 'Confirm_date'-'Create_date'>1, 'Quantity',
If('order_status' = 'B' and 'Confirm_date' is null and Today()-'Create_date'>1,'Quantity',0)) as Late_quantity
Regards,
Jagan.
Thank Jagan!
It works! But just another question: if I want to do something like: if 'Confirm_date' is not null, then..., how to code the "is not null" function?
Peter
Thank Jagan!
It works! But just another question: if I want to do something like: if 'Confirm_date' is not null, then..., how to code the "is not null" function?
Peter
use
not isnull(date)
Thanks Rajni!!
Peter