5 Replies Latest reply: Jul 19, 2016 4:55 AM by June Kim RSS

    way to work this formula on Qlik Sense

    June Kim

      Try to use this formula below, but Qlik Sense doesn't allow me to do so..

       

      Can someone edit this to work on the Qlik S please?

       

       

      Thank you

       

       

      if(isnull([SHIP_DT]=False and isnull([P_RETURN_DT])=False)) then

      (sum([SALE_RPRICE])*([ORDER_QTY]))*(-1)

      elseif (isnull([SHIP_DT])=False and isnull([P_RETURN_DT])=True) then

      (sum([SALE_RPRICE])*([ORDER_QTY]))

      else

      0

      END