wrong chart

[#1]

Dear,

I aspect to have the end of the  trend of YTD 2014 series with Year=2014 and  Order type =J;G around 800-1000 as showed in pivot table picture, instead it is 5000-6000 as in chart picture

the expression to calculate it is
rangesum(above(Sum({1<Year = {'2014'}, AlsisStatus = {'G','J'}>}CountOrder), 0, Rowno()))

please what is wrong?

[oknotsen]

I don't see what is wrong.

The other chart is showing a list of numbers that adds up to a number in the 5000-6000 range (after 50 weeks / 12 months), so it just seems correct.

Try to do this with less data and/or share that data.

Please also be a little bit more describing about what we are supposed to see / make up out of the screenshot. Thank you!

[Anonymous]

Are you using the same expression in the pivot table?

[Anonymous · Accepted solution]

Your spellchecker doesn't recognize AlsisStatus (?)

[#5]

Thank you very much for your kind reply

[#6]

Thank you very much for your feedback, therefore I just started with Qlikview, sometime I don't see obvious.