Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help INPUTFIELD performance

Hello
I am working with QlikView 10. In my project I need to work with 8 inputfield, but when reloading the script, the server consumes 8GB, when I run on my local machine with 2GB goes down, the CPU usage is normal.
The project requires the use of these 8 Inputfield but need a better memory performance in my project.

Someone can help me?

Thank you.
a Greeting

INPUTFIELD   XXXX_1, XXXX_2, .. XXXX_8;

Load

      RowNo() as InputSIMU,
     '1' as XXXX_1 ,
     '0' as XXXX_2,
               .
               .
     '0' as XXXX_8

AUTOGENERATE peek('InputSIMU', -1, 'Data');

1 Reply
pover
Partner - Master
Partner - Master

Since an inputfield can be any value, QlikView cannot compress the data as it usually does and it will always consume alot of memory.  I've gotten around this by creating a separate application with only the data that will change.  For example, when you make a forecast you don't need to have data older than 2009 in your model being inputfields.

Karl