topic Re: Accumulated value in Line Chart with 2 dimensions in App Development

Accumulated value in Line Chart with 2 dimensions

Mon, 27 Apr 2015 09:59:13 GMT

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!

Re: Accumulated value in Line Chart with 2 dimensions

morganaaron — Mon, 27 Apr 2015 10:05:00 GMT

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?

Re: Accumulated value in Line Chart with 2 dimensions

Mon, 27 Apr 2015 10:26:54 GMT

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!

Re: Accumulated value in Line Chart with 2 dimensions

morganaaron — Mon, 27 Apr 2015 11:08:53 GMT

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

Re: Accumulated value in Line Chart with 2 dimensions

Mon, 27 Apr 2015 13:04:47 GMT