topic sum(column) in QlikView

sum(column)

Thu, 06 Jun 2013 13:59:49 GMT

hello

I need to calculate the sum of a column and put it in an other one.

How can I do that?

alexandros17 — Thu, 06 Jun 2013 14:06:55 GMT

If the column name is for example COLXX (where you compute sum(nn)) then in the other column you can wrire

[COLXX] having, in this way the same result

Thu, 06 Jun 2013 14:22:54 GMT

I didn't get it

I created a table with 2 columns and one dimension

dimension= product

column1= quantity

column2=quantity/ sum(column1)

it doesn't work for the 2nd column

alexandros17 — Thu, 06 Jun 2013 14:34:10 GMT

column2=quantity/ [column1]

the syntax for column is column(n) where n is the number of expression starting from 1

Thu, 06 Jun 2013 14:43:23 GMT

syntax error

it doesn't work

jagan — Thu, 06 Jun 2013 15:24:52 GMT

Hi,

Try like this

quantity/ sum(TOTAL quantity)

Hope this helps you.

Regards,

Jagan.

Thu, 06 Jun 2013 16:18:58 GMT

thx