Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
GabrielOtet
Contributor III
Contributor III

Calculate TOTAL of a column

Hi,

 

Is it possible to calculate the percentage of the cell relative to the entire column?

Something like count(Field)/count(SUM Field for entire column).

I have tried many options (especially with TOTAL and filters) but none of them gave me the right answer.

The table is looking something like this:

Untitled.png

 

 

Labels (1)
1 Solution

Accepted Solutions
GabrielOtet
Contributor III
Contributor III
Author

In the meantime, I have found the solution, in case anyone wants to use it:

Count(field)
/
(RangeSum(Below(count(field),0,(NoOfRows()-RowNo()+1)))+RangeSum (above(count(field),1,(RowNo()-1))))

Basically there is the sum of all the values above and all the values below including the current one.

View solution in original post

1 Reply
GabrielOtet
Contributor III
Contributor III
Author

In the meantime, I have found the solution, in case anyone wants to use it:

Count(field)
/
(RangeSum(Below(count(field),0,(NoOfRows()-RowNo()+1)))+RangeSum (above(count(field),1,(RowNo()-1))))

Basically there is the sum of all the values above and all the values below including the current one.