Total Sum

Anonymous — Fri, 12 Jul 2013 15:28:06 GMT

Hi,

I got an expression that looks like this:

SUM

([$(='COST Part Cost Appproved '&vInflatedString&$(vCurrency))]) /
aggr(NODISTINCT
count({AS_Contract<$(vAS_ContractFilter)>}[CONTRACT_YEAR Contract ID])
,[CONTRACT_YEAR Contract Year],[VEHICLE Vehicle Type])

This works fine and gives me a result like:

total:15

The total I got is from the total mode option "sum of rows"

Now I need to calculate this total in an expression but I can't figure it out.

Does anybody have an idea?

Thx

Re: Total Sum

swuehl — Fri, 12 Jul 2013 15:46:48 GMT

That's not easy to answer without knowing your setting (used with which chart dimensions? data model?) and without knowing how these dollar sign expansions work in detail.

But you can look into the HELP, search for 'sum-of-rows in a pivot table using advanced aggregation' (even if you are not using a pivot table). It explains how you can emulate the sum of rows feature.

Looks like

sum( aggr(

SUM

CHARTDIM1, CHARTDIM2))

topic Total Sum in QlikView

Total Sum

Re: Total Sum