Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Eston_Sello
Contributor III
Contributor III

Percentage Calculation

Good day,

Please assist, I'm still new in Qlik.

I want to use grand total number to calculate the percentage but I struggling.

I have manually hard coded the grant total (424730) in the expression field to get my  percentages.

clipboard_image_1.png

 

Thanks in advance.

Labels (1)
  • Other

1 Solution

Accepted Solutions
DavidM
Partner - Creator II
Partner - Creator II

You need to use total function:

Sum(Postpaid)/Sum(Total [Calls Received])

View solution in original post

2 Replies
DavidM
Partner - Creator II
Partner - Creator II

You need to use total function:

Sum(Postpaid)/Sum(Total [Calls Received])

Eston_Sello
Contributor III
Contributor III
Author

Thanks you very much it worked.