Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Effect on performance and RAM usage due to addition of more sheets

Hi All,

I have weekly and monthly data in my document. I have created charts in different sheets for weekly and monthly as we have lot of changes between these views. please let me know how it is going to effect on performance and RAM usage.

Thanks,

Homprakash.

1 Reply
mov
Esteemed Contributor III

Re: Effect on performance and RAM usage due to addition of more sheets

We had a situation earlier this year when it took a documenmt too long to open up on QV server.  After long investigation, it turned out to be a large number of sheets that caused the problem.  The document had more than 30 sheets, almost all were with "conditional show" with complex conditions.
After simplifying conditions, open time was cut in half.  But the best effect was after removing most of the sheets.  Eventually we left only 5 or 6 sheets, and the problem was resolved.
There were no any problems with the other aspects of performance, nor any RAM issues in this situation.

Regards,
Michael

Community Browser