Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum(column)

hello

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

How can I do that?

6 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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
Partner - Champion III
Partner - Champion III

column2=quantity/ [column1]

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

Not applicable
Author

syntax error

it doesn't work

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try like this

quantity/ sum(TOTAL quantity)

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

thx