topic Re: Doubt with accumulated expression in QlikView

Doubt with accumulated expression

Tue, 24 Feb 2015 13:28:12 GMT

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

Re: Doubt with accumulated expression

robert_mika — Tue, 24 Feb 2015 14:50:43 GMT

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

];

Re: Doubt with accumulated expression

Oleg_Troyansky — Tue, 24 Feb 2015 14:55:44 GMT

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!

Re: Doubt with accumulated expression

Tue, 24 Feb 2015 14:56:16 GMT

I did this and it worked!

SUM({$< MonthYear= {"<=$(=MAX(MonthYear))"}, Month= , Year= >}Amount)

Re: Doubt with accumulated expression

robert_mika — Tue, 24 Feb 2015 14:59:08 GMT

Thanks Oleg..

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

Re: Doubt with accumulated expression

Oleg_Troyansky — Tue, 24 Feb 2015 15:56:22 GMT

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.

Re: Doubt with accumulated expression

Tue, 24 Feb 2015 15:57:13 GMT

thank you for your help