How to get sum of the quantity sold only when satisfying two conditions

[#1]

Hi there,

I would like to put the number in KPI only calculating hardware sold in 2015.

Fields required (Values) to obtain the answers are Quantity sold, year (2015, 2014), and Product category (Hardware and consumables).

Your thoughts are highly appreciated.

Many thanks.

[sunny_talwar]

May be this:

=Sum({<[Product category] = {'Hardware'}, year = {2015}>} [Quantity sold])

[#3]

Thanks,

I tried the formula but it doesn't filter 2015 year...

[sunny_talwar]

May be the field name is Year or YEAR? QlikView is case sensitive.

[#5]

Thanks! It works!

[sunny_talwar]

Great, close the thread in that case