Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
1st column is Cluster and second is Country.
Can you try this
RangeSum(Above(TOTAL
Sum({<Monthnum = {">=$(=Max(Monthnum) -11) <=$(=Max(Monthnum))"}>} absDiff)
, 0, RowNo(TOTAL)))
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.