Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

andrefpc
Contributor II

Performance upgrade

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!

5 Replies
Employee
Employee

Re: Performance upgrade

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)

aveeeeeee7en
Valued Contributor III

Re: Performance upgrade

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.

andrefpc
Contributor II

Re: Performance upgrade

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

aveeeeeee7en
Valued Contributor III

Re: Re: Performance upgrade

See the Attached.

aveeeeeee7en
Valued Contributor III

Re: Re: Performance upgrade

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