topic Re: Performance upgrade in QlikView

Performance upgrade

andrefpc — Thu, 20 Feb 2014 17:46:10 GMT

Hello experts! In my QV project I use a lot of expressions, for performance upgrade I was thinking of store every expression in a .txt which will be included in the script, my question is: the expressions will be calculated only once and presented where needed or, for every object the expression is recalculated?

Thanks!

Re: Performance upgrade

Clever_Anjos — Thu, 20 Feb 2014 17:50:14 GMT

For every selection all expressions are recalculated, but in a very optimized way (using cache)

I don´t think you´ll perceive difference using the expressions based on a txt file.

You should work into optimizing every expression (using flags, etc)

Re: Performance upgrade

aveeeeeee7en — Thu, 20 Feb 2014 17:51:34 GMT

Hi Andre

I rather recommend you to create Variable instead of storing expressions in a .txt file that's a wrong approach.

Create variable once and enter your expression value there. This is one time activity.

After creating variable for a particular expression call that expression eg. vLastQuarterSales in your Bar Chart, Straight Table, Text Box, anywhere. It will just work fine and easier for you.

It's the Best Practice. Also your Application Performance will surely be increased.

Re: Performance upgrade

andrefpc — Thu, 20 Feb 2014 17:57:38 GMT

Thanks for your reply Nag, my question is...every time I call that variable in different objects is it recalculated?

Re: Re: Performance upgrade

aveeeeeee7en — Thu, 20 Feb 2014 18:33:25 GMT

See the Attached.

Re: Re: Performance upgrade

aveeeeeee7en — Thu, 20 Feb 2014 18:38:25 GMT

Yes, it will Change According to your Dimensions which you will use in your different Objects.