Qlik Community

Ask a Question

Scalability

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
lse
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.

Labels (1)
2 Replies
rva_heldendaten
Partner
Partner

Hi!

I remember this information from Qonnections quite some years ago.

Is it still valid for Qlikview12 and Qlik Sense?

Thx,

Roland

lse
Employee
Employee
Author

This should still be valid.

br

/lars