Column() function

[#1]

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 :

• this expression : SUM(turnover) / SUM(orders) ?
• or, this expression : Column(1) / Column(2) ?

Maybe, this is exactly the same...

Thanks in advance for your answers.

Damien

[kaushalview]

Hi,

This both expression  give u same result.

1. SUM(turnover) / SUM(orders)

2. Column(1) / Column(2)

[CELAMBARASAN · Accepted solution]

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

[jagan]

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.

[#5]

Thanks both of you !