Qlikview sum quantity per year issue

[#1]

Hello

I am new to Qlikview.

I am running the following query in a Text object

=sum({<Year={1999}>} amount_sold)

I'd like to sum all quantity sold for the year 1999.

Instead of summing the quantities for the year 1999 as requested, Qlikview will always do the sum for the year currently selected.

For instance, if I select year 2000 in my app, Qlikview will do the sum of quantities for the year 2000

For instance, if I select year 2001 in my app, Qlikview will do the sum of quantities for the year 2001

If I do not select a year, Qlikview will do the sum of quantities for all the years.

What should I change in my expression to have Qlikview do the sum for the year 1999 no matter which year is selected in the app?

Thanks

[Kushal_Chawda]

try this

=sum({1<Year={'1999'}>} amount_sold)

[sunny_talwar]

Is the field name year or Year? QlikView is case sensitive and you will need to put the right case

May be this is what you need -> =sum({<year={1999}>} amount_sold)

year with a lower case