6 Replies Latest reply: Sep 7, 2012 4:02 AM by peter2011 RSS

    How to make Multiple 'if' function

      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?