Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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

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.

5 Replies
MVP
MVP

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

May be this:

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

Not applicable

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

Thanks,

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

MVP
MVP

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

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

Not applicable

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

Thanks! It works!

MVP
MVP

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

Great, close the thread in that case