topic Re: Compounded Expression in Line Chart in QlikView

Compounded Expression in Line Chart

nwilliams — Thu, 26 Nov 2015 08:58:17 GMT

Hi,

I'm trying to create a line chart that has a compounded expression. For example, I have the following data

Jan - 10

Feb - 9

Mar - 11

Apr - 15

May - 5

What I want to show in the chart are the following values

Jan - 10

Feb - 19

Mar = 30

Apr - 45

May - 50

So this will effectively create a line that always curves up. Any ideas how this can be achieved?

Gysbert_Wassenaar — Thu, 26 Nov 2015 10:14:36 GMT

Enable the Full Accumulation option for the expression. Or use something like rangesum(above(sum(Value),0,rowno())) as expression.

buzzy996 — Thu, 26 Nov 2015 10:41:13 GMT

use this,