Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
infosense_devel
Contributor II

RangeSum expression with Grand total for Dimension.

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.

table.png

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

property.png

thanks in advance.

3 Replies

Re: RangeSum expression with Grand total for Dimension.

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

infosense_devel
Contributor II

Re: RangeSum expression with Grand total for Dimension.

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?

Re: RangeSum expression with Grand total for Dimension.

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

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()