<?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 Resolve the Following Equation to knowledge dimension () in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Resolve-the-Following-Equation-to-knowledge-dimension/m-p/472784#M176536</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I need to be able to resolve the following equation to know the dimension in the pivot table automatically. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I need to take out VehicleGroupName={'DimensionName'}&amp;gt;} and havr it automatically respect the dimension in the pivot table. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Count({&amp;lt;Inv={"=sum({&amp;lt;VehicleGroupName={'DimensionName'}&amp;gt;}aggr(exp(sum(log(1+Value1)))-1, VehicleGroupName,Inv)) &lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;lt;&amp;nbsp;&amp;nbsp; &lt;/P&gt;&lt;P&gt; (exp( SUM( TOTAL&amp;lt;VehicleGroupName, BusinessDate&amp;gt;&amp;nbsp; aggr(log(1+SUM({&amp;lt;VehicleGroupName={'DimensionName'}&amp;gt;}PValue2)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; /SUM({&amp;lt;VehicleGroupName={'DimensionName'}&amp;gt;}PValue3))&lt;/P&gt;&lt;P&gt; , VehicleGroupName, BusinessDate)))-1)"&lt;/P&gt;&lt;P&gt;}&amp;gt;} Distinct Inv)&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 26 Feb 2013 17:01:52 GMT</pubDate>
    <dc:creator />
    <dc:date>2013-02-26T17:01:52Z</dc:date>
    <item>
      <title>Resolve the Following Equation to knowledge dimension ()</title>
      <link>https://community.qlik.com/t5/QlikView/Resolve-the-Following-Equation-to-knowledge-dimension/m-p/472784#M176536</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I need to be able to resolve the following equation to know the dimension in the pivot table automatically. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I need to take out VehicleGroupName={'DimensionName'}&amp;gt;} and havr it automatically respect the dimension in the pivot table. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Count({&amp;lt;Inv={"=sum({&amp;lt;VehicleGroupName={'DimensionName'}&amp;gt;}aggr(exp(sum(log(1+Value1)))-1, VehicleGroupName,Inv)) &lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;lt;&amp;nbsp;&amp;nbsp; &lt;/P&gt;&lt;P&gt; (exp( SUM( TOTAL&amp;lt;VehicleGroupName, BusinessDate&amp;gt;&amp;nbsp; aggr(log(1+SUM({&amp;lt;VehicleGroupName={'DimensionName'}&amp;gt;}PValue2)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; /SUM({&amp;lt;VehicleGroupName={'DimensionName'}&amp;gt;}PValue3))&lt;/P&gt;&lt;P&gt; , VehicleGroupName, BusinessDate)))-1)"&lt;/P&gt;&lt;P&gt;}&amp;gt;} Distinct Inv)&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 26 Feb 2013 17:01:52 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Resolve-the-Following-Equation-to-knowledge-dimension/m-p/472784#M176536</guid>
      <dc:creator />
      <dc:date>2013-02-26T17:01:52Z</dc:date>
    </item>
  </channel>
</rss>

