<?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 Create a New Field in Pivot Table in a VBScript Macro in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Create-a-New-Field-in-Pivot-Table-in-a-VBScript-Macro/m-p/674704#M245007</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Is it possible to create a new field in a QV document in a VBscript macro ? This new field would be used as a dimension in a Pivot Table. New field value is an expression which contains a call to a function in my VBScript.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Here an example : I create a pivot table with a dimension "country". I write in VBScript a function getCountries() which returns an association between countries, areas and subareas. I would like to add two dimensions in my pivot table, for area and subarea. How to do it with VBSCript code ? &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Sun, 29 Jun 2014 11:54:13 GMT</pubDate>
    <dc:creator />
    <dc:date>2014-06-29T11:54:13Z</dc:date>
    <item>
      <title>Create a New Field in Pivot Table in a VBScript Macro</title>
      <link>https://community.qlik.com/t5/QlikView/Create-a-New-Field-in-Pivot-Table-in-a-VBScript-Macro/m-p/674704#M245007</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Is it possible to create a new field in a QV document in a VBscript macro ? This new field would be used as a dimension in a Pivot Table. New field value is an expression which contains a call to a function in my VBScript.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Here an example : I create a pivot table with a dimension "country". I write in VBScript a function getCountries() which returns an association between countries, areas and subareas. I would like to add two dimensions in my pivot table, for area and subarea. How to do it with VBSCript code ? &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sun, 29 Jun 2014 11:54:13 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Create-a-New-Field-in-Pivot-Table-in-a-VBScript-Macro/m-p/674704#M245007</guid>
      <dc:creator />
      <dc:date>2014-06-29T11:54:13Z</dc:date>
    </item>
  </channel>
</rss>

