topic Extra entry on chart when using above() in QlikView

Extra entry on chart when using above()

Fri, 22 May 2009 21:30:44 GMT

Hi Folks

I have a line/bar chart where onve of the expressions is:

Sum

(Value1) - above(Sum(Value1))

This gives me the movement between two periods as the dimension is QuarterEnd, the problem is that when I use the above() function the chart will give me an additional plot/data after the last Quarter. For example, I have selected a reporting date of 30 Jun 2008 (which gives me a dataset of everything prior to that date) but my chart gives me a bar after 30 jun 2008 with no date on it.

Anybody experienced this?

If you have, have you found a solution?

Cheers,

Nigel.

Extra entry on chart when using above()

sathishkumar_go — Fri, 22 May 2009 22:24:02 GMT

Hi try this fromula

if(date = '30 jun 2008',sum(Values1),sum(Values1) - above(sum(Values1))

I hope it ll help for u

-Sathish

Extra entry on chart when using above()

rwunderlich — Sat, 23 May 2009 06:38:54 GMT

Does it look different if you use:

sum(Value1) - above(Sum(Value1))

-Rob