topic Column() function in QlikView

Column() function

Tue, 06 Mar 2012 09:38:54 GMT

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

Column() function

kaushalview — Tue, 06 Mar 2012 09:43:19 GMT

Hi,

This both expression give u same result.

1. SUM(turnover) / SUM(orders)

2. Column(1) / Column(2)

Column() function

CELAMBARASAN — Tue, 06 Mar 2012 09:50:00 GMT

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

Column() function

jagan — Tue, 06 Mar 2012 10:40:34 GMT

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.

Column() function

Tue, 06 Mar 2012 10:47:14 GMT

Thanks both of you !