<?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: Allocated memory exceeded after loading the qvw file in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862618#M1257796</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;Generally this types of issues are solved by increasing the RAM in your machine. If you have any high end machine then check in that machine.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;This issues are performance issues.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Also with some careful precautions this can be avoided&lt;/P&gt;&lt;P&gt;- Don't display huge data in tables like Table box, Straight Table, Pivot Table,&lt;/P&gt;&lt;P&gt;- Don't display all charts in a single shot, show/hide by using buttons or split into sheets.&lt;/P&gt;&lt;P&gt;- Perform all possible calculations in the script level itself and bring some flags wherever required.&lt;/P&gt;&lt;P&gt;- Load only required data instead of loading all the data in the database and required columns so that the size of the QVW file will be reduced.&lt;/P&gt;&lt;P&gt;- Always make your key columns as numeric, so that the joins will be faster.&amp;nbsp; If your data is Text then use AutoNumber(),&lt;/P&gt;&lt;P&gt;- If you are not using Time part in the date fields for analysis remove it by using Date(Floor(DateFieldName)), a lot of memory will be saved.&lt;/P&gt;&lt;P&gt;- Restrict displaying huge data in tables by forcing users to select some filters.&lt;/P&gt;&lt;P&gt;- Try to create Star schema data model.&lt;/P&gt;&lt;P&gt;- Last but not the least remove all your synthetic keys and Circular references for better performance&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hope this helps you.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Jagan.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 22 Jul 2015 10:52:05 GMT</pubDate>
    <dc:creator>jagan</dc:creator>
    <dc:date>2015-07-22T10:52:05Z</dc:date>
    <item>
      <title>Allocated memory exceeded after loading the qvw file</title>
      <link>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862612#M1257777</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello All,&lt;/P&gt;&lt;P&gt;We are using version 11.20 personal deskop edition. when loaded with qvw file we get an error indicating "Allocated memory exceeded" on the dashboards. Can`anyone give us documentation pointers to fix the error...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;QVW File was created on Licensed version of QlikView and we are opening on a Personal Edition&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Appreciate your help...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Subbarao&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 26 Jan 2026 18:19:17 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862612#M1257777</guid>
      <dc:creator />
      <dc:date>2026-01-26T18:19:17Z</dc:date>
    </item>
    <item>
      <title>Re: Allocated memory exceeded after loading the qvw file</title>
      <link>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862613#M1257781</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Have a look at discussion below:&lt;/P&gt;&lt;P&gt;&lt;A _jive_internal="true" data-containerid="2003" data-containertype="14" data-objectid="368295" data-objecttype="2" href="https://community.qlik.com/message/368295#368295"&gt;&lt;SPAN style="color: #3778c7;"&gt;Allocated memory exceeded in qvw file&lt;/SPAN&gt;&lt;/A&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 01 May 2015 15:34:35 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862613#M1257781</guid>
      <dc:creator>jpenuliar</dc:creator>
      <dc:date>2015-05-01T15:34:35Z</dc:date>
    </item>
    <item>
      <title>Re: Allocated memory exceeded after loading the qvw file</title>
      <link>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862614#M1257785</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Personal Edition can't open QVW-files that have been made in a licensed version unless it is made by Qlik employees who has a special license that enables them to make such QVW-files...&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 09 Jul 2015 18:48:21 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862614#M1257785</guid>
      <dc:creator>petter</dc:creator>
      <dc:date>2015-07-09T18:48:21Z</dc:date>
    </item>
    <item>
      <title>Re: Allocated memory exceeded after loading the qvw file</title>
      <link>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862615#M1257788</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;A href="https://community.qlik.com/people/ksubbarao"&gt;ksubbarao&lt;/A&gt;‌&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;You are opening the QVW in Personal Edition. Did you lease the license from server?&lt;STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 22 Jul 2015 03:54:59 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862615#M1257788</guid>
      <dc:creator>qlikviewwizard</dc:creator>
      <dc:date>2015-07-22T03:54:59Z</dc:date>
    </item>
    <item>
      <title>Re: Allocated memory exceeded after loading the qvw file</title>
      <link>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862616#M1257791</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;This could happen in case you are using heavy calculation in front end that requires more ram to process it.&lt;/P&gt;&lt;P&gt;You have 2 options&lt;/P&gt;&lt;P&gt;1) try by increasing ram&lt;/P&gt;&lt;P&gt;2) if you can try to take your front end calculation to backed and use simple expression in front end.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hopefully it should resolve your issue.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;P&gt;ASHFAQ&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 22 Jul 2015 06:58:21 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862616#M1257791</guid>
      <dc:creator>ashfaq_haseeb</dc:creator>
      <dc:date>2015-07-22T06:58:21Z</dc:date>
    </item>
    <item>
      <title>Re: Allocated memory exceeded after loading the qvw file</title>
      <link>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862617#M1257795</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi &lt;STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;A href="https://community.qlik.com/people/ashfaq_haseeb"&gt;ashfaq_haseeb&lt;/A&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;Good points. Thank you. You have been not in community since many days.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 22 Jul 2015 10:22:20 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862617#M1257795</guid>
      <dc:creator>qlikviewwizard</dc:creator>
      <dc:date>2015-07-22T10:22:20Z</dc:date>
    </item>
    <item>
      <title>Re: Allocated memory exceeded after loading the qvw file</title>
      <link>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862618#M1257796</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;Generally this types of issues are solved by increasing the RAM in your machine. If you have any high end machine then check in that machine.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;This issues are performance issues.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Also with some careful precautions this can be avoided&lt;/P&gt;&lt;P&gt;- Don't display huge data in tables like Table box, Straight Table, Pivot Table,&lt;/P&gt;&lt;P&gt;- Don't display all charts in a single shot, show/hide by using buttons or split into sheets.&lt;/P&gt;&lt;P&gt;- Perform all possible calculations in the script level itself and bring some flags wherever required.&lt;/P&gt;&lt;P&gt;- Load only required data instead of loading all the data in the database and required columns so that the size of the QVW file will be reduced.&lt;/P&gt;&lt;P&gt;- Always make your key columns as numeric, so that the joins will be faster.&amp;nbsp; If your data is Text then use AutoNumber(),&lt;/P&gt;&lt;P&gt;- If you are not using Time part in the date fields for analysis remove it by using Date(Floor(DateFieldName)), a lot of memory will be saved.&lt;/P&gt;&lt;P&gt;- Restrict displaying huge data in tables by forcing users to select some filters.&lt;/P&gt;&lt;P&gt;- Try to create Star schema data model.&lt;/P&gt;&lt;P&gt;- Last but not the least remove all your synthetic keys and Circular references for better performance&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hope this helps you.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Jagan.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 22 Jul 2015 10:52:05 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Allocated-memory-exceeded-after-loading-the-qvw-file/m-p/862618#M1257796</guid>
      <dc:creator>jagan</dc:creator>
      <dc:date>2015-07-22T10:52:05Z</dc:date>
    </item>
  </channel>
</rss>

