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

    Creating an expression line in script using another

      Hi

       

      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?

       

      Rob