Qlik Community

Qlik Scalability

A group dedicated to advancing Qlik scalability and performance. In this group we will share knowledge on how to perform load tests of Qlik products.

Highlighted
Employee
Employee

Quick Tips #13 - Calculated dimensions

Calculated dimension is a great way to view data over values in creative ways, especially when developing. There's a cost involved in this, like every other calculation. The total sum of this "cost" can be higher that desired.

Simple text extractions or field value manipulations are not very expensive. Date/time manipulation on the other hand is unfortunately on the more expensive end of the scale. If performance is vital, then the best approach is, if possible, to perform field manipulation in the load-script, instead of repeating the calculation over and over for every click and every user.

One thing to be aware of is the price of having more than one field in the calculation.

This will exclude the objects result set from using the cache So if the expression is complex/heavy/slow it will continue to be so even if the exact result was calculated previously.

Cheers from the Scalability Team.

2 Replies
Partner
Partner

Re: Quick Tips #13 - Calculated dimensions

Hi!

I remember this information from Qonnections quite some years ago.

Is it still valid for Qlikview12 and Qlik Sense?

Thx,

Roland

Employee
Employee

Re: Quick Tips #13 - Calculated dimensions

This should still be valid.

br

/lars