topic Re: Cumulative Sum with many dimensions and expression sorted in QlikView

Cumulative Sum with many dimensions and expression sorted

jchoucq — Thu, 29 Mar 2012 16:08:02 GMT

Hi,

in a straight table, i've got 3 dimensions and an expression which i sort descending. Everything is ok.

Then, i would like, to have another column which must be the cumulative sum.

I must keep the sort order and have a cumulative sum from the first row to the last one.

Whatever the solution i try (Full Accumulation, Above, SumRange ..), it doesn't work !

Does anyone have an idea ?

You can look at my attached qvw.

Regards,

Johann

Re: Cumulative Sum with many dimensions and expression sorted

lenka_kruse — Thu, 29 Mar 2012 16:53:35 GMT

Hi,

I got at least the cumulation by changing the expression to this:

rangesum(above(total cumul), sum(CA))

but I don't know why the sorting won't work - looks to me like a bug, since the sorting is shot to hell as soon as the second expression is added/activated. I'm sure that's not supposed to happen

Good luck, Lenka

Re: Cumulative Sum with many dimensions and expression sorted

jchoucq — Thu, 29 Mar 2012 20:16:44 GMT

Thanks a lot, lenka. Your expression is the correct one.

Moreover, By using the sort tab and the expression to sort in each dimension i get the right sorting.

Johann

Re: Cumulative Sum with many dimensions and expression sorted

Fri, 22 Jun 2012 13:38:55 GMT

Do you have any hint for eralising the same, but in a line chart?

2 dimensions

Date

Sales Group

1 expression

sum(Quantity)

I would like the chart to look like, besides a line for each SG, a line on top which is the sum of all the quantity of each SG.

Thank you!