Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

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...