Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I was wondering if using the Column() function in a pivot table would optimized my application.
Basically, let's say that I have 1 dimension : time, and 2 expressions : Sum(turnover), Sum(orders).
In order to measure the average turnover per order in a third column, is it better to do :
Maybe, this is exactly the same...
Thanks in advance for your answers.
Damien
Hi,
Performance wise Column(1)/Column(2) is better than SUM(turnover) / SUM(orders) because Column functions takes values from the table(chart) which is already calculated no need to evaluate it again.
Celambarasan
Hi,
This both expression give u same result.
1. SUM(turnover) / SUM(orders)
2. Column(1) / Column(2)
Hi,
Performance wise Column(1)/Column(2) is better than SUM(turnover) / SUM(orders) because Column functions takes values from the table(chart) which is already calculated no need to evaluate it again.
Celambarasan
Hi,
Using Column(1) / Column(2) is better than using SUM(turnover) / SUM(orders).
Because while using Column() you are getting the precalculated value, which is already calculated, so better performance. If we use SUM(turnover) / SUM(orders), qlikview again calculates the same another time.
So using the Column(1) / Column(2) or [Expression 1]/[Expression 2] is better.
Regards,
Jagan.
Thanks both of you !