6 Replies Latest reply: Feb 6, 2013 4:39 AM by Rob Franklin RSS

    Creating an expression line in script using another



      I have created a line of script in Qlikview as follows:


      if([Status] = '3. Project Submitted',1,if([Status] = '4C. Bid Under Negotiation/Awaiting Award

      ',1,0)) as [Pending Count],


      This produces a 1 if the line has the status 3 or 4c.


      What I want to do now is to create a column that multiplies [Pending Count] by a field [Application Value]


      However every time I do it says 'no such field as [Pending Count].


      I am sure I am just having a newbie moment, but can anyone help?