2 Replies Latest reply: Jan 29, 2013 4:11 AM by Stephane Janin RSS

    Expression : condition before a sum (condition avant de sommer)

      Bonjour / Hello


      I just started with Qlikview but i could not find out what i easily did with MS Access :


      I want to sum a numeric field but only when a varchar field contains part of a text which is in another field.

      This should be very simple..


      Field 1 : murex

      Field 2 : direct costs murex

      Field 3 : costs (numeric field)


      I want to make a sum only for the rows for which we find "murex" in "direct costs murex"   (we exclude direct costs application XXYY)


      A few try but that does not work :


      If(Field 2 like '*Field 1*'; Sum (costs);0)


      Thanks for your help !