Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

cumulative total issue

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

2 Replies
MVP
MVP

Re: cumulative total issue

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.

Not applicable

Re: cumulative total issue

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

Community Browser