Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, Patrick.
try it:
sum({< Month = {"<=$(=max(Month))"} >} Amount)
or see in atachment
Hi, Patrick.
try it:
sum({< Month = {"<=$(=max(Month))"} >} Amount)
or see in atachment
Thanks a lot !