topic Re: calculation in inline is it allowed in QlikView https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820079#M289119 <HTML><HEAD></HEAD><BODY><P>Load id,cost,(cost/10) Inline [</P><P>101,500</P><P>102,790</P><P>103,900</P><P>];</P></BODY></HTML> Tue, 20 Jan 2015 10:25:30 GMT anbu1984 2015-01-20T10:25:30Z calculation in inline is it allowed https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820077#M289117 <HTML><HEAD></HEAD><BODY><P>when i scripted as follows i cud not get data for cost/10...y it is so?</P><P>load * Inline [ id,cost,(cost/10)</P><P>101,500</P><P>102,790</P><P>103,900</P><P>];</P></BODY></HTML> Tue, 20 Jan 2015 10:04:54 GMT https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820077#M289117 2015-01-20T10:04:54Z Re: calculation in inline is it allowed https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820078#M289118 <HTML><HEAD></HEAD><BODY><P>You can try doing it after the Inline using Resident of that Table and then Droping it.</P></BODY></HTML> Tue, 20 Jan 2015 10:19:44 GMT https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820078#M289118 2015-01-20T10:19:44Z Re: calculation in inline is it allowed https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820079#M289119 <HTML><HEAD></HEAD><BODY><P>Load id,cost,(cost/10) Inline [</P><P>101,500</P><P>102,790</P><P>103,900</P><P>];</P></BODY></HTML> Tue, 20 Jan 2015 10:25:30 GMT https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820079#M289119 anbu1984 2015-01-20T10:25:30Z Re: calculation in inline is it allowed https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820080#M289120 <HTML><HEAD></HEAD><BODY><P>Try like</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">load <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> id,cost,(cost/10) As NewCost</SPAN> Inline [ </P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">id,cost</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">101,500</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">102,790</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">103,900</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">];</P></BODY></HTML> Tue, 20 Jan 2015 10:37:37 GMT https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820080#M289120 senpradip007 2015-01-20T10:37:37Z Re: calculation in inline is it allowed https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820081#M289121 <HTML><HEAD></HEAD><BODY><P>which table 2 drop n y 2 drop it?</P></BODY></HTML> Tue, 20 Jan 2015 10:56:20 GMT https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820081#M289121 2015-01-20T10:56:20Z Re: calculation in inline is it allowed https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820082#M289122 <HTML><HEAD></HEAD><BODY><P>it gives error dude s it cant find the field names u specified...</P><P>field names r needed prior 2 data</P></BODY></HTML> Tue, 20 Jan 2015 10:58:11 GMT https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820082#M289122 2015-01-20T10:58:11Z Re: calculation in inline is it allowed https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820083#M289123 <HTML><HEAD></HEAD><BODY><P>This is what I meant</P><P>Table_Temp:</P><P>load * Inline [ id,cost</P><P>101,500</P><P>102,790</P><P>103,900</P><P>];</P><P></P><P>Table:</P><P>Load</P><P>id,</P><P>cost,</P><P>(cost/10)</P><P>Resident Table_Temp<SPAN style="font-size: 10pt; line-height: 1.5em;">;</SPAN></P><P>Drop Table Table_Temp;</P></BODY></HTML> Fri, 23 Jan 2015 09:57:27 GMT https://community.qlik.com/t5/QlikView/calculation-in-inline-is-it-allowed/m-p/820083#M289123 2015-01-23T09:57:27Z