Ratio in Pivot Table

ismailsari — Mon, 13 Apr 2026 11:30:58 GMT

Hello,

In the Pivot Table, as shown in the table below, I would like to calculate two different ratios.

One is the ratio of the totals obtained directly from the Qlik tool within themselves, and the other is the ratio of the row total within itself.

Is it possible for me to set up this structure?

Re: Ratio in Pivot Table

rwunderlich — Mon, 13 Apr 2026 12:07:51 GMT

In your General Total Avg expression, use the TOTAL keyword to indicate you want the denominator to be the total for all rows. Like this:

Sum([General Total]) / Sum(TOTAL [General Total])

-Rob