Sum selected Months

[#1]

Hi !

I have a little problem and hope you can help me. I have some periods an values. When i select a month i like to display the sum of this month with all other periods in this year before. Example:

When i select May, I need the sum of Jan,Feb;Mar,Apr and May.

I found a example here in the forum witch is near my problem:

http://community.qlik.com/forums/p/16410/64106.aspx#64106

I have tryed to play around with this formula, but i didnt find the solution.

I hope you can help me.

Best regards from Vienna

Patrick

[sparur · Accepted solution]

Hi, Patrick.

try it:

sum({< Month = {"<=$(=max(Month))"} >} Amount)

or see in atachment

[#3]

Thanks a lot !