16 Replies Latest reply: Oct 20, 2010 7:54 PM by John Witherspoon RSS

    Creating values in a field based on values in two other fields

      Hi.

      I have a table that looks like the one below:

      Cue IncommingCalls AnsweredCalls
      Sales 5 4
      Support 3 2

      What I would like to do is adding a field that displays a 0 if the value of the Cue field is support.
      It would then look like this:

      Cue IncommingCalls AnsweredCalls AnsCalls-Support
      Sales 5 4 4
      Support 3 2 0

      There is probably an easy solution to this but I'm a beginner when it comes to QlikView.

      I'm guessing that it might be possible to solve this with load inline.