topic Re: RangeSum expression with Grand total for Dimension. in QlikView

RangeSum expression with Grand total for Dimension.

infosense_devel — Tue, 19 Jun 2018 12:35:32 GMT

Hello All,

i have scenario where i have pivot table with two dimension and one expression.

in expression we are using Rangesum() as per below.

=RangeSum(Before(Sum({<Common_Month = ,REC_TYPE = {InvoiceDateRec}>} (RAGLDA_ACCTD_AMOUNT * XRATE_CONST * RATE)), 0, ColumnNo()))

my table layout is as per below.

I need Month Wise total column at right side of the table.

i have checked "Show partial Sum" check box on "presentation" tab of property, but still i am not able to see column wise total.

thanks in advance.

sunny_talwar — Tue, 19 Jun 2018 12:41:15 GMT

Isn't the Jun value (in the above screenshot) the total value you would see?

infosense_devel — Tue, 19 Jun 2018 19:39:46 GMT

i have presented my issue by simplifying it.

but assume that if i have requirement to show total column at right side of my total then?

can we achieve it with rangesum() in expression?

sunny_talwar — Tue, 19 Jun 2018 19:44:46 GMT

Not entirely sure it would show, bit it can be done using Dimensionality() function.