topic Add calculated field in the load script in QlikView https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786745#M278334 <HTML><HEAD></HEAD><BODY><P><BR />Hi All</P><P></P><P>In the load script of the qv file (in attachment) I want to add a new calculated field</P><P></P><P>NetWorkDays</P><P></P><P></P><P><SPAN style="color: #000000; font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Datum 1: Lancering Workflow]</SPAN><SPAN style="color: #000000; font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Datum 7: Finale goedkeuring]</SPAN><SPAN style="color: #000000; font-size: 8pt;">,) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="color: #000000; font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Doorlooptijd in werkdagen (etappe)]</SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000;">,'##,00', </SPAN></SPAN></P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P></P><P></P><P></P><P></P><P></P><P>During the reload I got the message : Field names must be unique within table MainTable: <BR /> </P><P>I don't see the problem.</P><P></P><P>Can somebody help me ?</P><P></P><P>Qv in attachment.</P><P></P><P>Thanks in advance</P><P></P><P>Marc </P></BODY></HTML> Thu, 25 Dec 2014 07:30:29 GMT 2014-12-25T07:30:29Z Add calculated field in the load script https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786745#M278334 <HTML><HEAD></HEAD><BODY><P><BR />Hi All</P><P></P><P>In the load script of the qv file (in attachment) I want to add a new calculated field</P><P></P><P>NetWorkDays</P><P></P><P></P><P><SPAN style="color: #000000; font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Datum 1: Lancering Workflow]</SPAN><SPAN style="color: #000000; font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Datum 7: Finale goedkeuring]</SPAN><SPAN style="color: #000000; font-size: 8pt;">,) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="color: #000000; font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Doorlooptijd in werkdagen (etappe)]</SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000;">,'##,00', </SPAN></SPAN></P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P></P><P></P><P></P><P></P><P></P><P>During the reload I got the message : Field names must be unique within table MainTable: <BR /> </P><P>I don't see the problem.</P><P></P><P>Can somebody help me ?</P><P></P><P>Qv in attachment.</P><P></P><P>Thanks in advance</P><P></P><P>Marc </P></BODY></HTML> Thu, 25 Dec 2014 07:30:29 GMT https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786745#M278334 2014-12-25T07:30:29Z Re: Add calculated field in the load script https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786746#M278335 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>NetWorkDays(1,2,) as [Doorlooptijd in werkdagen]<STRONG>,'##,00',</STRONG></P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>The problem is the bold part. That creates a field with the name '##,00'. Since that happens twice in the load statement you get the duplicate field error. I have no idea what you intended that '##,00' to do, but it doesn't do anything useful and is causing the error you see.</P></BODY></HTML> Thu, 25 Dec 2014 07:52:37 GMT https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786746#M278335 Gysbert_Wassenaar 2014-12-25T07:52:37Z Re: Add calculated field in the load script https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786747#M278336 <HTML><HEAD></HEAD><BODY><P>Hi Marc,</P><P></P><P>Unable to open the file, will u pls provide some sample data.</P><P></P><P>Thank you</P><P></P><P>Regards,</P><P>Sub2u.</P></BODY></HTML> Thu, 25 Dec 2014 08:15:15 GMT https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786747#M278336 2014-12-25T08:15:15Z Re: Add calculated field in the load script https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786748#M278337 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Problem is in the mean while solved by Gysbert Wassenaar.</P><P></P><P>Problem was:</P><P></P><P>The problem is the bold part. That creates a field with the name '##,00'. Since that happens twice in the load statement you get the duplicate field error.</P><P></P><P>Thanks a lot.</P><P></P><P>Merry Chrsitmas and Happy New Year.</P><P></P><P>Marc</P></BODY></HTML> Thu, 25 Dec 2014 09:50:03 GMT https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786748#M278337 2014-12-25T09:50:03Z Re: Add calculated field in the load script https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786749#M278338 <HTML><HEAD></HEAD><BODY><P>Hello Gysbert</P><P></P><P>Thanks a lot. Indead '##,00', is useless.</P><P></P><P>Is removed and OK.</P><P></P><P>Merry Chrsitmas and Happy New Year.</P><P></P><P>Grt</P><P></P><P>Mar</P></BODY></HTML> Thu, 25 Dec 2014 09:50:03 GMT https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786749#M278338 2014-12-25T09:50:03Z Re: Add calculated field in the load script https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786750#M278339 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Merry Chrsitmas and Happy New Year to you too! </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Can you mark this discussion as Answered?</SPAN></P></BODY></HTML> Thu, 25 Dec 2014 09:53:37 GMT https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786750#M278339 Gysbert_Wassenaar 2014-12-25T09:53:37Z Re: Add calculated field in the load script https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786751#M278340 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert</P><P></P><P>Ok. Normally I can mark the response as “Juiste oplossing” but this is not available.</P><P></P><P>How can I mark this discussion as answered ?</P><P></P><P>Thanks a lot.</P><P></P><P>Marc</P></BODY></HTML> Thu, 25 Dec 2014 14:47:39 GMT https://community.qlik.com/t5/QlikView/Add-calculated-field-in-the-load-script/m-p/786751#M278340 2014-12-25T14:47:39Z