Doubt with accumulated expression

[#1]

Hi

I have to sum(AMOUNT) from the start of the dates to the selected month.

This was working but i don't know why with a few changes i made it doesn't work anymore.

SUM({$< Month= {"<=$(= Only(Month))"}  >}AMOUNT)

Any ideas?

Greetings

[robert_mika]

Your Expression works for me

(well not sure what your data set thu)

Data:

LOAD * INLINE [

Monht, Type, AMOUNT

1, X, 10

2, X, 20

1, Y, 30

4,Y,20

];

[Oleg_Troyansky]

Robert - your expression "works" only by accident... Notice that the field Month is misspelled in the load, hence the SA expression is simply ignored.

Jeremias - we need to know a bit more. The expression itself looks fine, but there might be other reasons for it not to work - data, chart dimensions, etc... Can you post an example?

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

[#4]

I did this and it worked! SUM({$< MonthYear= {"<=$(=MAX(MonthYear))"}, Month= , Year= >}Amount)

[robert_mika]

Thanks Oleg..

I should put my head down now,....

[Oleg_Troyansky · Accepted solution]

Jeremias - the ONLY() function required only one MonthYear to be available, and that's probably why your formula didn't work. The function MAX() allows multiple months to be available.

[#7]

thank you for your help