topic Variable Question in QlikView

Variable Question

Tue, 13 Mar 2012 03:56:01 GMT

In one of my pivot tables I get the grand totals for each column (formula) showing. I want to convert that total into a variable so that I can calculate the percentage of each row as a percent of the total for each column. How can I declare the column total as variable. Please helpl

Variable Question

Qvmaster2019 — Tue, 13 Mar 2012 04:54:45 GMT

Is it possible to attached the file you are currently working on?

Variable Question

jagan — Tue, 13 Mar 2012 07:48:33 GMT

Hi,

Create a variable and give the expression you used in the Pivot table.

Now use this variable in your expression

=Sum(Revenue)/$(vTotal)

or you can use directly without creating any variable

=Sum(Revenue)/Sum(TOTAL Revenue)

TOTAL doesn't consider the dimension, so you will get the Column total when you use TOTAL in expression.

Regards,

Jagan.