topic Running total in Pivot Table in QlikView

Running total in Pivot Table

dinuwanbr — Wed, 20 Jul 2016 04:14:05 GMT

Hi All,

I have a Strange Problem. i'm Calculating running total and a contribution for branch and segment wise. The expression I used to calculate running total as follows.

RangeSum(Above(Sum(Net_Value),0,RowNo()))

But when i do'n select any Branch the result is wrong and when I select a branch the result is correct. But I need to generate that report for all the branches at once. (with out select any branch)

I have attached snap shots on both the cases. Unable to upload a sample.

Can anyone help me?

Thanx in advance.

Rgds,

Tharindu

Re: Running total in Pivot Table

jonathandienst — Wed, 20 Jul 2016 04:58:55 GMT

I expect you need a TOTAL statement in the expression:

RangeSum(Above(TOTAL Sum(Net_Value),0,RowNo()))

RangeSum(Above(Sum(Net_Value),0,RowNo(TOTAL)))

or some combination of the above

Re: Running total in Pivot Table

Wed, 20 Jul 2016 06:09:20 GMT

try this i hope it will work

RangeSum(Above(Sum(Net_Value))

Re: Running total in Pivot Table

dinuwanbr — Mon, 25 Jul 2016 06:00:18 GMT

Dear Jonathan,

Thank you very much for ur reply. But still the same issue.

BR,

Tharindu

Re: Running total in Pivot Table

dinuwanbr — Mon, 25 Jul 2016 06:01:21 GMT

Dear Krishna,

Thank you very much for ur reply.

But it's not working.

Rgds,

Tharindu