Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks in advance.
You need to use total function:
Sum(Postpaid)/Sum(Total [Calls Received])
You need to use total function:
Sum(Postpaid)/Sum(Total [Calls Received])
Thanks you very much it worked.