Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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
Luminary Alumni
Luminary Alumni

Hi,

Try like this

quantity/ sum(TOTAL quantity)

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

thx