topic Re: RAM and how reduce the size of qvw in QlikView

RAM and how reduce the size of qvw

demcug82 — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

i have an app with 3 pivot table and 3 inputfield (what if analysis)

The size it's 600 mega, but when i open the file (on server), uses 15 giga of RAM (of 32 on server). Too when i only save the file.

First pivot table has 70 k id distinct and 180 column (1 for every day)

Second pivot it's for weekly, then only 15 column.

Third pivot it's with 365 column

If delete 3 inputfield the size reduce at 120 mega and uses 2 giga of RAM.

This .qvw It's called from another .qvw passing parameters including the id. that reduce a pivot in a record.

More time when i try to open the qvw on access point i receive session timeout error and i have seen that the giga arrive at 28 (of 32).

Then the problem It seems to be the inputfield.

There is somethings that i can do?

P.s.

I already used analyzer to delete field not used

avinashelite — Fri, 26 Aug 2016 10:03:09 GMT

Are you creating the INPUTFIELD in script ?? or your making use of the variables in the UI inputbox ??

Colin-Albert — Fri, 26 Aug 2016 10:10:56 GMT

This post may give an insight on what is happening How tp find the size of RAM. | Qlik Community

demcug82 — Fri, 26 Aug 2016 11:23:18 GMT

in the script:

INPUTFIELD [Initial On-hand quantity WIF] ,[Requirement quantity WIF],[Shipped Quantity WIF]

demcug82 — Fri, 26 Aug 2016 12:48:26 GMT

Hi Colin,

can u help me with this information? (order by bytes order by size)

In 2° photo the first 3 are the inputfield.