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
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?