topic Re: Creating an expression line in script using another in QlikView https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408457#M487420 <HTML><HEAD></HEAD><BODY><P>sadly its confidential information.</P><P></P><P>I will see if I can generate some data to show the problem.</P></BODY></HTML> Wed, 06 Feb 2013 09:17:08 GMT 2013-02-06T09:17:08Z Creating an expression line in script using another https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408455#M487418 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have created a line of script in Qlikview as follows:</P><P></P><P>if([Status] = '3. Project Submitted',1,if([Status] = '4C. Bid Under Negotiation/Awaiting Award</P><P>',1,0)) as [Pending Count],</P><P></P><P>This produces a 1 if the line has the status 3 or 4c.</P><P></P><P>What I want to do now is to create a column that multiplies [Pending Count] by a field [Application Value]</P><P></P><P>However every time I do it says 'no such field as [Pending Count].</P><P></P><P>I am sure I am just having a newbie moment, but can anyone help?</P><P></P><P>Rob</P></BODY></HTML> Wed, 06 Feb 2013 08:57:24 GMT https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408455#M487418 2013-02-06T08:57:24Z Re: Creating an expression line in script using another https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408456#M487419 <HTML><HEAD></HEAD><BODY><P>PFA it may help you.</P></BODY></HTML> Wed, 06 Feb 2013 09:15:42 GMT https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408456#M487419 sreenivas 2013-02-06T09:15:42Z Re: Creating an expression line in script using another https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408457#M487420 <HTML><HEAD></HEAD><BODY><P>sadly its confidential information.</P><P></P><P>I will see if I can generate some data to show the problem.</P></BODY></HTML> Wed, 06 Feb 2013 09:17:08 GMT https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408457#M487420 2013-02-06T09:17:08Z Re: Creating an expression line in script using another https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408458#M487421 <HTML><HEAD></HEAD><BODY><P>Hi Rob,</P><P>are you doing something like this :</P><P></P><P>LOAD</P><P></P><P>....</P><P></P><P>if([Status] = '3. Project Submitted',1,if([Status] = '4C. Bid Under Negotiation/Awaiting Award</P><P>',1,0)) as [Pending Count],</P><P></P><P>[Application Value] * [Pending Count],</P><P></P><P>....</P><P></P><P>FROM .....</P><P></P><P>In this case you can't do it.</P><P>What you can do is:</P><P></P><P>TAB_A:</P><P>LOAD</P><P>....</P><P></P><P>if([Status] = '3. Project Submitted',1,if([Status] = '4C. Bid Under Negotiation/Awaiting Award</P><P>',1,0)) as [Pending Count],</P><P>....</P><P></P><P>FROM .....;</P><P></P><P>INNER JOIN LOAD "KeyField", [Application Value] * [Pending Count] as Field2</P><P>RESIDENT TAB_A;</P><P></P><P></P><P>Hope it helps</P><P>Regards</P><P>Giampiero</P></BODY></HTML> Wed, 06 Feb 2013 09:24:56 GMT https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408458#M487421 2013-02-06T09:24:56Z Re: Creating an expression line in script using another https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408459#M487422 <HTML><HEAD></HEAD><BODY><P>Rob, I think you misunderstood Sreenivas. He wasn't asking for you to provide an example but was attaching a potential solution.</P><P>Jonathan</P></BODY></HTML> Wed, 06 Feb 2013 09:26:37 GMT https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408459#M487422 Anonymous 2013-02-06T09:26:37Z Re: Creating an expression line in script using another https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408460#M487423 <HTML><HEAD></HEAD><BODY><P>Jonathan, thank you but the original reply said can you attach a qvw file, it has been editted or deleted it seems. </P></BODY></HTML> Wed, 06 Feb 2013 09:38:45 GMT https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408460#M487423 2013-02-06T09:38:45Z Re: Creating an expression line in script using another https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408461#M487424 <HTML><HEAD></HEAD><BODY><P>Thank you all, in the end I did this another way with this expression in the table, rather than the script</P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">sum</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">({$&lt;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">[Pending Count]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">= {1}&gt;} </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">aggr</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">[Application Value]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">, </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">[Project Code]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">)) </SPAN></P></BODY></HTML> Wed, 06 Feb 2013 09:39:44 GMT https://community.qlik.com/t5/QlikView/Creating-an-expression-line-in-script-using-another/m-p/408461#M487424 2013-02-06T09:39:44Z