topic Re: cumulative total issue in QlikView

cumulative total issue

Wed, 10 Apr 2013 07:28:31 GMT

Hi All,

I have a issue to display cumulative sum in pivot table.Now am using the expression as

if(dimensionality()=0,0,RangeSum(Above(TOTAL Column(1),0,NoOfRows(TOTAL)))).

Iam not getting the Total Value for columnname Cumulative in the attached pivot table.So,Kindly all help me to solve this issue.

Thanks & Regards

Kartheesan

Re: cumulative total issue

swuehl — Wed, 10 Apr 2013 14:48:50 GMT

In your expression, you are explicitely returning 0 for your total line (dimensionality() = 0).

Instead, try using a sum-of-rows-in-pivot-table expression (check the HELP for more details, there is a whole chapter that covers that).

It would probably look similar to

if(dimensionality()=0,

sum( aggr( YOUREXPRESSIONCOLUMN1, Location, Month) )

RangeSum(Above(TOTAL Column(1),0,NoOfRows(TOTAL)))

)

where you need to replace YOUREXPRESSIONCOLUMN1 with the appropriate expression and double check your aggr() dimension field names.

Re: cumulative total issue

Thu, 11 Apr 2013 07:28:04 GMT

Hi,

It works fine.The third dimension dragged into vertically alignment.The cumulative total gives correct result.Incase the third dimension dragged into horizontal alignment.The total become 0.

Thanks & Regards

Kartheesan