Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
maarhenn
Contributor
Contributor

SUM IF with AGGREGATE Function

Hello - I am new to Qlik and need to do a IF and aggregate function. Is this possible?

This is what I have but get an ERROR:

SUM(IF(Status= 'Eligible',IF(Status= 'Out Of Contract',(SUM(Revenue)/COUNT(member_id)))))

Thanks!

1 Reply
vishsaggi
Champion III
Champion III

Are you looking for this? If not can you elaborate a little more please on what exactly you are trying to calculate.

= IF(Status= 'Eligible', Sum({< Status= {'Out Of Contract'} >} Revenue)/COUNT(member_id))