topic Re: Performance in QlikView in QlikView

Performance in QlikView

Mon, 26 Jan 2026 18:19:17 GMT

Hi everyone,

I have a doubt about the best option for get the best performance in my QVW application. I have 5 options in my sheet, all of them use a similar table with the same dimensions and expressions (in this one, I only change a value for the tables). For a table, I use 18 expressions so, for all of them, I use 90!!

My cuestion is about what option is better to get the best performance for my application. I have to create 5 tables or I have to create a table with 90 expressions?

Thank you in advance for your help.

Jon

Re: Performance in QlikView

Peter_Cammaert — Fri, 18 Nov 2016 09:10:28 GMT

That's a difficult one. I'm not even sure that a single table with 18 expressions is even a good idea, let alone 5 of them. It all depends on the amount of data you put into these expressions. For example, the effect of splitting one object with 90 expressions in 5 with 18 expressions each may be minimal if they only process a few hundred pre-aggregated rows.

The best way to get an idea of the perfomance difference when handling your full set of records is to do a test: 1 table with 36 expressions vs. two objects with 18 expressions each. You can use the Calc time & Memory columns on the Sheet Properties->Objects tab to get an idea about performance. I'm more inclined towards the latter...

Best,

Peter

Re: Performance in QlikView

Anonymous — Wed, 23 Nov 2016 23:15:36 GMT

May be look at options to handle them at script. What the size of your data?

Re: Performance in QlikView

marcus_sommer — Thu, 24 Nov 2016 08:10:46 GMT

Beside considerations if really 18 expressions will be needed I would tend to use only one table which changed the dimension(s) dynamic to my selections.

- Marcus

Re: Performance in QlikView

Anonymous — Fri, 25 Nov 2016 14:19:54 GMT

Hi Jon,

If you really want to improve speed, I recommend you read this interesting document about QlikView optimization.

See u!

Re: Performance in QlikView

Fri, 25 Nov 2016 14:41:48 GMT

I can't remove data, I have 75MB in QVDs. The problem is that I have to work with them.

Thanks!

Re: Performance in QlikView

Fri, 25 Nov 2016 14:43:32 GMT

Thanks for the tutorial! It's very interesting!

Re: Performance in QlikView

Anonymous — Fri, 25 Nov 2016 14:46:53 GMT