set analysis with variables issue

[#1]

Hi all,

This is the expression in by text box:

=sum({<month={$(vMaxMonth)}>}Revenue)&' '&sum({<month={$(vPrevMonth)}>}Revenue)

And this is the values of the variables:

this expression gives me empty result.

I tried this way:

=sum({<month={'$(vMaxMonth)'}>}Revenue)&' '&sum({<month={'$(vPrevMonth)'}>}Revenue)

this one shows me total sum without any filter.

when I try regular list box filter each date gives me different number.

where am I wrong?

Thanks,

Boris

[preminqlik]

seems to be you are complicating that by caculating in backend . you can caclulate it in front end also ...any way try this ...

sum(if(Month=$(vMaxMonth),Revenue))&' '&sum(if(Month=$(vPrevMonth),Revenue))