Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Improving the application performance - Using Variable

Hi All,

I have a query wrt using variable.

If a expression is used more than one time in a chart with a different condition, in this scenario if we remove the expression with variable and use it several time, will it improve the performance/decrease the calc time?

Actually, I just did the same -  expression was too huge and used twice with different condition. So, I created variable and replaced in both the place. Likewise there was several expression repeated and I did the same for all.

But instead of decreasing the CALC time of the object it increased. Before replacing with variable it was 1700 ms and after replacing with variable it got increased to 8075 ms.

PLEASE help in understanding where I am going wrong?



Pritam Deb