<?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 Pivot table problem. in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Pivot-table-problem/m-p/328974#M582377</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 have a big table that has lots of coeficients calculated (over 15). after that it calculates 5-10 more fields, based on the first 15 coeficients.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I did this in expressions, referring to each of the coeficients in the next expresions. I can not make it all in one expresion (or at least for the dimantional ones) because if I replace the name of the expresion with the code used for calculating it becomes way too big for qv to hendle it and it crashes when I paste it (over 2000 chars and over 500 lines in total over 1mil of characters).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I was wondering as some of my dimensions are calculated nad located in the expressions I can not use them on creating the pivot table, is there a way to fix this, as for no wI need to export the table and reload it to use it for a pivot table.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is there a way to use calculated values of one object for creating a new one (first will be the table of coeficients and the other will be the pivot table).&lt;/P&gt;&lt;P&gt;Or is it a way to use expression as a dimention in the pivot table?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 18 Nov 2011 09:08:35 GMT</pubDate>
    <dc:creator />
    <dc:date>2011-11-18T09:08:35Z</dc:date>
    <item>
      <title>Pivot table problem.</title>
      <link>https://community.qlik.com/t5/QlikView/Pivot-table-problem/m-p/328974#M582377</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 have a big table that has lots of coeficients calculated (over 15). after that it calculates 5-10 more fields, based on the first 15 coeficients.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I did this in expressions, referring to each of the coeficients in the next expresions. I can not make it all in one expresion (or at least for the dimantional ones) because if I replace the name of the expresion with the code used for calculating it becomes way too big for qv to hendle it and it crashes when I paste it (over 2000 chars and over 500 lines in total over 1mil of characters).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I was wondering as some of my dimensions are calculated nad located in the expressions I can not use them on creating the pivot table, is there a way to fix this, as for no wI need to export the table and reload it to use it for a pivot table.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is there a way to use calculated values of one object for creating a new one (first will be the table of coeficients and the other will be the pivot table).&lt;/P&gt;&lt;P&gt;Or is it a way to use expression as a dimention in the pivot table?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 18 Nov 2011 09:08:35 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Pivot-table-problem/m-p/328974#M582377</guid>
      <dc:creator />
      <dc:date>2011-11-18T09:08:35Z</dc:date>
    </item>
  </channel>
</rss>

