Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))