Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Accumulated value in Line Chart with 2 dimensions

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!

4 Replies
morganaaron
Valued Contributor

Re: Accumulated value in Line Chart with 2 dimensions

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?

Not applicable

Re: Accumulated value in Line Chart with 2 dimensions

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
Valued Contributor

Re: Accumulated value in Line Chart with 2 dimensions

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

Not applicable

Re: Accumulated value in Line Chart with 2 dimensions

Capturar.JPG