Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
GabrielOtet
New 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
New Contributor III

Re: Calculate TOTAL of a column

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
New Contributor III

Re: Calculate TOTAL of a column

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