topic Re: calculated field in load script in QlikView https://community.qlik.com/t5/QlikView/calculated-field-in-load-script/m-p/1282463#M623386 <HTML><HEAD></HEAD><BODY><P>thanks, </P><P>I was hoping to avoid joining them. will try to just move the one field.</P></BODY></HTML> Mon, 19 Dec 2016 14:38:18 GMT 2016-12-19T14:38:18Z calculated field in load script https://community.qlik.com/t5/QlikView/calculated-field-in-load-script/m-p/1282461#M623384 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I am trying to figure out how to make a calcultaed field in the load script. </P><P></P><P>If(ActHourRate &lt;&gt; 0, TicTacHours * ActHourRate, TicTacHours * ListHourRate)</P><P></P><P>All fields except ListHourRate comes from TicTacTime. </P><P></P><P>Can someone please point me in the right direction? </P><P></P><P>thanks</P><P>g</P><P><IMG alt="Skärmklipp.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/146994_Skärmklipp.PNG" style="height: 255px; width: 620px;" /></P></BODY></HTML> Mon, 19 Dec 2016 10:22:12 GMT https://community.qlik.com/t5/QlikView/calculated-field-in-load-script/m-p/1282461#M623384 2016-12-19T10:22:12Z Re: calculated field in load script https://community.qlik.com/t5/QlikView/calculated-field-in-load-script/m-p/1282462#M623385 <HTML><HEAD></HEAD><BODY><P>If you want to do a calculation in the script then all fields necessary for the calculation need to exist in one table. That means you'll have to join tables together first. Or perhaps you can use a double applymap to get the listhourrate in the tictactime table.</P></BODY></HTML> Mon, 19 Dec 2016 14:35:19 GMT https://community.qlik.com/t5/QlikView/calculated-field-in-load-script/m-p/1282462#M623385 Gysbert_Wassenaar 2016-12-19T14:35:19Z Re: calculated field in load script https://community.qlik.com/t5/QlikView/calculated-field-in-load-script/m-p/1282463#M623386 <HTML><HEAD></HEAD><BODY><P>thanks, </P><P>I was hoping to avoid joining them. will try to just move the one field.</P></BODY></HTML> Mon, 19 Dec 2016 14:38:18 GMT https://community.qlik.com/t5/QlikView/calculated-field-in-load-script/m-p/1282463#M623386 2016-12-19T14:38:18Z