<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Modify field value with macro in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Modify-field-value-with-macro/m-p/255641#M96742</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;EM style="font-family: trebuchet ms,geneva;"&gt;Hi Hubert,&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;EM style="font-family: trebuchet ms,geneva;"&gt;Have you specified "%WORST_SFFR_ITEM") as InputField in the Load Script? If not please use the InputField keyword in Load Script and also look at this &lt;A _jive_internal="true" href="https://community.qlik.com/message/136710#136710"&gt;thread&lt;/A&gt;.&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;EM style="font-family: trebuchet ms,geneva;"&gt;I hope this helps!&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;&lt;EM style="font-family: trebuchet ms,geneva;"&gt;Cheers - DV&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 18 Oct 2011 12:02:21 GMT</pubDate>
    <dc:creator>IAMDV</dc:creator>
    <dc:date>2011-10-18T12:02:21Z</dc:date>
    <item>
      <title>Modify field value with macro</title>
      <link>https://community.qlik.com/t5/QlikView/Modify-field-value-with-macro/m-p/255640#M96741</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I am trying to change the values of fields using macro.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have commented the algorithm (for loop) and tried very simple test : &lt;/P&gt;&lt;P&gt;fld.SetInputFieldValue 0, "999"&lt;/P&gt;&lt;P&gt;I only want that the first row is set to 999, but event this does not work.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Here is the output when I press the "Test" button in QV...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG src="https://community.qlik.com/" /&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="error modifying field.bmp" class="jive-image" src="https://community.qlik.com/legacyfs/online/7926_error+modifying+field.bmp" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any idea?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thank you all for the help!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hubert&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 18 Oct 2011 08:12:57 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Modify-field-value-with-macro/m-p/255640#M96741</guid>
      <dc:creator />
      <dc:date>2011-10-18T08:12:57Z</dc:date>
    </item>
    <item>
      <title>Re: Modify field value with macro</title>
      <link>https://community.qlik.com/t5/QlikView/Modify-field-value-with-macro/m-p/255641#M96742</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;EM style="font-family: trebuchet ms,geneva;"&gt;Hi Hubert,&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;EM style="font-family: trebuchet ms,geneva;"&gt;Have you specified "%WORST_SFFR_ITEM") as InputField in the Load Script? If not please use the InputField keyword in Load Script and also look at this &lt;A _jive_internal="true" href="https://community.qlik.com/message/136710#136710"&gt;thread&lt;/A&gt;.&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;EM style="font-family: trebuchet ms,geneva;"&gt;I hope this helps!&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;&lt;EM style="font-family: trebuchet ms,geneva;"&gt;Cheers - DV&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 18 Oct 2011 12:02:21 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Modify-field-value-with-macro/m-p/255641#M96742</guid>
      <dc:creator>IAMDV</dc:creator>
      <dc:date>2011-10-18T12:02:21Z</dc:date>
    </item>
    <item>
      <title>Modify field value with macro</title>
      <link>https://community.qlik.com/t5/QlikView/Modify-field-value-with-macro/m-p/255642#M96743</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello DV&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Many thanks for the hint : it solved everything !!&lt;/P&gt;&lt;P&gt;Just had to add &lt;/P&gt;&lt;P&gt;INPUTFIELD %WORST_SFFR_ITEM&lt;/P&gt;&lt;P&gt;before the load statement and let's rock!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Once again : warm thanks!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hubert&lt;/P&gt;&lt;P&gt;&lt;EM style="font-family: trebuchet ms,geneva;"&gt; &lt;/EM&gt;&lt;EM style="font-family: trebuchet ms,geneva;"&gt;&lt;BR /&gt;&lt;/EM&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 19 Oct 2011 03:59:00 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Modify-field-value-with-macro/m-p/255642#M96743</guid>
      <dc:creator />
      <dc:date>2011-10-19T03:59:00Z</dc:date>
    </item>
    <item>
      <title>Modify field value with macro</title>
      <link>https://community.qlik.com/t5/QlikView/Modify-field-value-with-macro/m-p/255643#M96744</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;EM style="font-family: trebuchet ms,geneva;"&gt;Hi Hubert,&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;EM style="font-family: trebuchet ms,geneva;"&gt;I am glad you got it working. You are welcome &lt;IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /&gt;&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;EM style="font-family: trebuchet ms,geneva;"&gt;&lt;STRONG&gt;Cheers - DV&lt;/STRONG&gt;&lt;BR /&gt;&lt;/EM&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 19 Oct 2011 08:17:38 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Modify-field-value-with-macro/m-p/255643#M96744</guid>
      <dc:creator>IAMDV</dc:creator>
      <dc:date>2011-10-19T08:17:38Z</dc:date>
    </item>
  </channel>
</rss>

