topic Rangesum,above in QlikView

Rangesum,above

Tue, 22 Jun 2010 07:10:46 GMT

I have an chart there I use rangesum(above()) function. The problem is that för the current year I want the line to be cutted at the present month.

The chart looks like this

I want the chart look like this:

I have tried to use rangesum(above(...............),0,5) instead of rangesum(above(...............),0,12) but the chart does not look like I want anyway [:(]

Can anyone help?

Liivi

Rangesum,above

Miguel_Angel_Baeyens — Tue, 22 Jun 2010 08:53:03 GMT

Hello Liivi,

It happens to me that one workaround may be not use full accumulation if your other expressions allow you so. If not, another tip, as this is the behaviour I've seen when full accumulation is used, is to draw your lines "invisible". To do so, click on the [+] sign on the left of your expression, expand to "Backgruond Color" and set something like

If(dimension <= condition, ARGB(0, 255, 255, 255))

Hope that helps

Rangesum,above

Tue, 22 Jun 2010 10:56:50 GMT

None of the tips seems to work 😞

Rangesum,above

Miguel_Angel_Baeyens — Tue, 22 Jun 2010 11:18:30 GMT

Hello Liiviv,

It's working fine here... How is your chart designed? Are you using full acumulation?

Rangesum,above

Tue, 22 Jun 2010 13:10:13 GMT

Hi,

The accumulation is done inte the function.

Rangesum,above

johnw — Tue, 22 Jun 2010 23:34:17 GMT

How about adding to your set analysis to exclude anything past the current month? Then future months should sum to 0, so the rangesum() should remain flat.

Rangesum,above

Mon, 28 Jun 2010 10:26:34 GMT

It did not help either 😞

Rangesum,above

johnw — Mon, 28 Jun 2010 18:11:39 GMT

Maybe this?

if(Month<=month(today()),rangesum(...))

Rangesum,above

Tue, 29 Jun 2010 11:42:20 GMT

With som miner fixes it works!!! Thanx a lot!!!

Rangesum,above

guyvermeiren — Tue, 29 Jun 2010 13:04:12 GMT

Hello Liiiv,

Another idea is to set the Backgound color to White for the future months.

Is used something like this and it works:

=if(Num(Period)<Num(Month(Today()))-1,Black(255),White(0))

Period is the Month in my data

Kind regards