3 Replies Latest reply: Mar 3, 2014 10:39 AM by Florian Pennetzdorfer RSS

    Equivalent to IFERROR function in Excel?

    Florian Pennetzdorfer

      Hey,

       

      is there a Qlikview-equivalent to the IFERROR function in Excel ... IFERROR(value, value_if_error) ?

      The main advantage: With that function you only have to write/calculate the value expression once.

       

      In Qlikview you need to do something like

      if(isNull(value_expression), value_if_error, value_expression)

       

      Or am I missing something?

       

      Regards,

      Florian