topic Qlikview sum quantity per year issue in QlikView

Qlikview sum quantity per year issue

Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 06 May 2016 16:25:02 GMT

try this

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

sunny_talwar — Fri, 06 May 2016 16:25:54 GMT

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