Accumulated value in Line Chart with 2 dimensions

[#1]

Dear All,

I'd like to create a line chart which includes 2 dimensions, one is for X-Axis and the other is for dividing lines in several. However, the value showed on this chart should be calculated by accumulated measure. Do you have any idea how to write this formula for this measure to achieve this function?

In fact, I have to achieve it by QlikSense, where has no function but only having to use formula.

I post my sample here, hope anyone could give me a favor. Thanks in advance!

[morganaaron]

What are you attempting to do with the chart? If you just want to accumulate over the ranking_bin for each competitiveproductid, simply tick the "full accumulation" box for that expression on the expressions tab.

Otherwise, what is it you're trying to accumulate, and over what?

[#3]

Hi Aaron,

Thank you for your quick reply. However, because I use QlikSense to do it, which has no "full accumulation" box, I have to write formula to achieve it.

Yeah, I'd like to accumulate over the ranking_bin for each CompetitiveProductId. So, do you have any idea?

Thanks a lot!

[morganaaron]

Ah - you've accidentally posted this in the Qlikview App Development folder!

You'll want to use RangeSum in combination with the Above function, something like:

RangeSum(Above(Sum(Change_Factor), 0, (Left(Ranking_Bin, 3) + 4) / 5))

Though the above would only work if you don't have CompetitiveProductId as a dimension.

Try moving the thread to the Qlik Sense forum and you may get a more helpful reply!

Aaron

[#5]