Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to use SUM with two criteria in KPI?


Hi guys,


I have a table with product sales in two conditions: Normal and Promotion; from June / 16 to August / 16.


I need a KPI that returns me the TOTAL sales in June ONLY PRODUCT PROMOTION that sold in August / 16.


Does anyone have any idea how can I do?


Follows attached my app qvf.


Thanks!



1 Reply
mov
Esteemed Contributor III

Re: How to use SUM with two criteria in KPI?

Your expression worked for me after I re-typed the double-quote characters in this part:

{"=Sum({1<[Mês-Ano]={'ago 2016'},[Condição]={'Promoção'}>} Valor) > 0"}

They didn't look right...