8 Replies Latest reply: Jul 21, 2016 6:36 AM by Digvijay Singh RSS

    Way to fix expressions

    June Kim

      Can someone fix these formulas in order to work on Qlik Sense?

       

      1 -

      IF [P_RETURN_DT]=[date] and ISNULL([P_RETURN_DT])=FALSE then

      [ORDER_QTY]*[SALE_RPRICE]*-1

      ELSE

      0

      END

       

      2 -

      IF [SHIP_DT]=[date] and ISNULL([SHIP_DT])=FALSE then

      [ORDER_QTY]*[SALE_RPRICE]

      ELSE

      0

      END

       

      3 - If I'd like to add those two expressions, should I do like this?

                -  [1]+[2]

       

       

       

       

      Thank you.