topic Re: running total is not working for multiple dimension in QlikView

running total is not working for multiple dimension

ajaymehtaece — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to calculate the running total in qlik using formula

RangeSum (above(TOTAL Sum({<Monthnum={">=$(=Max(Monthnum) -11) <=$(=Max(Monthnum))"}>}absDiff),0,RowNo()))

this formula is working fine for single dimension lets say country,however its not working for multiple dimensions.

kindly help me by providing the solution.

Thanks in advance.Working for one dimensionnot working for multiple dimension

Re: running total is not working for multiple dimension

ramasaisaksoft — Tue, 08 Jan 2019 07:24:14 GMT

Hi Ajay,

in your below table you divided into country twice.so i hope if you remove 2 country field hope you will get the expected solution i mean both up and down tables will show same number.

please find the attachment

let me show correct way,if i miss understood your requirement.

Re: running total is not working for multiple dimension

ajaymehtaece — Tue, 08 Jan 2019 07:57:28 GMT

1st column is Cluster and second is Country.

Re: running total is not working for multiple dimension

sunny_talwar — Tue, 08 Jan 2019 13:02:29 GMT

Can you try this

RangeSum(Above(TOTAL 
   Sum({<Monthnum = {">=$(=Max(Monthnum) -11) <=$(=Max(Monthnum))"}>} absDiff)
, 0, RowNo(TOTAL)))

Re: running total is not working for multiple dimension

Donicc — Thu, 10 Jan 2019 23:03:32 GMT

Looks like your running totals are working as expected:

I think the problem is you asked Qlikview to show a sum of the running totals. IMO, a running total over a non sequential dimension is not any more useful than the partial sums for the Cluster.