Total Sales minus Current Year

[Anonymous]

Hello,

¿There is a way to get on a button the total sales minus current year?

Thank you

[tom2qlik]

You could try set analysis in the button expression.

Sum(Sales)-Sum({$<This Year = {1}>}Sales)

Use you identifier/flag for this year in the set analysis of the second sum.

[tom2qlik]

I may have misunderstood what you are asking.

Do you want the calculation in a text object that appears once you click on the button?

If you can explain what you want the button to do, that help in providing a more accurate answer.

Tom

[Anonymous]

Hello,

you are right, i ment in a text objext

[sunny_talwar]

May be like this

Sum({<Year = {"$(='<=' & Max(Year))"}>}Sales)

[tom2qlik]

Within the text object text box -

=Sum(Sales)-Sum({$<Year = {This year}>}Sales)

That should work.