Nested IF statment limit, need an alternitave

Thu, 05 Apr 2012 20:02:18 GMT
Ok I remember reading somewhere that there is a limit to nested IF statments and I am pretty sure I have gone over that limit. Does anyone have any thoughts on how I can keep the same results with a different approach?
I basically have a field with 7 results. I need to do a different set analysis on each distinct pairing which there are 122 of. Set of 0,1,2,3,4,5,6,7
Here is the full formula:
if(count(GetFieldSelections([EmployeeCompany]))=0 or count(GetFieldSelections([Employee Company]))=7,sum({<[Company ID]={'E11','F11','D11','A11','C11','G11','B11'}>}[Sales  Revenue]),
if(GetFieldSelections([EmployeeCompany])='F11',sum({<[Company ID]={'F11'}>}[Sales  Revenue]),if(GetFieldSelections([EmployeeCompany])='E11',sum({<[Company ID]={'E11'}>}[Sales  Revenue]),if(GetFieldSelections([EmployeeCompany])='D11',sum({<[Company ID]={'D11'}>}[Sales  Revenue]),if(GetFieldSelections([EmployeeCompany])='A11',sum({<[Company ID]={'A11'}>}[Sales  Revenue]),if(GetFieldSelections([EmployeeCompany])='C11',sum({<[Company ID]={'C11'}>}[Sales  Revenue]),if(GetFieldSelections([EmployeeCompany])='G11',sum({<[Company ID]={'G11'}>}[Sales  Revenue]),if(GetFieldSelections([EmployeeCompany])='B11',sum({<[Company ID]={'B11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','D11','A11','C11','G11'), sum({<[Company ID]={'E11','F11','D11','A11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','D11','A11','C11','B11'), sum({<[Company ID]={'E11','F11','D11','A11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','D11','A11','G11','B11'), sum({<[Company ID]={'E11','F11','D11','A11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','D11','C11','G11','B11'), sum({<[Company ID]={'E11','F11','D11','C11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','A11','C11','G11','B11'), sum({<[Company ID]={'E11','F11','A11','C11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','D11','A11','C11','G11','B11'), sum({<[Company ID]={'E11','D11','A11','C11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','A11','C11','G11','B11'), sum({<[Company ID]={'F11','D11','A11','C11','G11','B11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','D11','C11','G11'),sum({<[Company ID]={'E11','F11','D11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','D11','C11','B11'),sum({<[Company ID]={'E11','F11','D11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','D11','G11','B11'),sum({<[Company ID]={'E11','F11','D11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','A11','C11','G11'),sum({<[Company ID]={'E11','F11','A11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','A11','C11','B11'),sum({<[Company ID]={'E11','F11','A11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','A11','G11','B11'),sum({<[Company ID]={'E11','F11','A11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([Employee Company]),'E11','F11','C11','G11','B11'),sum({<[Company ID]={'E11','F11','C11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','D11','A11','C11','G11'),sum({<[Company ID]={'E11','D11','A11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','D11','A11','C11','B11'),sum({<[Company ID]={'E11','D11','A11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','D11','A11','G11','B11'),sum({<[Company ID]={'E11','D11','A11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','D11','C11','G11','B11'),sum({<[Company ID]={'E11','D11','C11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','A11','C11','G11','B11'),sum({<[Company ID]={'E11','A11','C11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','A11','C11','G11'),sum({<[Company ID]={'F11','D11','A11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','A11','C11','B11'),sum({<[Company ID]={'F11','D11','A11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','A11','G11','B11'),sum({<[Company ID]={'F11','D11','A11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','C11','G11','B11'),sum({<[Company ID]={'F11','D11','C11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','A11','C11','G11','B11'),sum({<[Company ID]={'F11','A11','C11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'D11','A11','C11','G11','B11'),sum({<[Company ID]={'D11','A11','C11','G11','B11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','D11','G11'),sum({<[Company ID]={'E11','F11','D11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','D11','B11'),sum({<[Company ID]={'E11','F11','D11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','A11','C11'),sum({<[Company ID]={'E11','F11','A11','C11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','A11','G11'),sum({<[Company ID]={'E11','F11','A11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','A11','B11'),sum({<[Company ID]={'E11','F11','A11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','C11','G11'),sum({<[Company ID]={'E11','F11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','C11','B11'),sum({<[Company ID]={'E11','F11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','G11','B11'),sum({<[Company ID]={'E11','F11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','D11','A11','C11'),sum({<[Company ID]={'E11','D11','A11','C11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','D11','A11','G11'),sum({<[Company ID]={'E11','D11','A11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','D11','A11','B11'),sum({<[Company ID]={'E11','D11','A11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([Employee Company]),'E11','D11','C11','G11'),sum({<[Company ID]={'E11','D11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','D11','C11','B11'),sum({<[Company ID]={'E11','D11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','D11','G11','B11'),sum({<[Company ID]={'E11','D11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','A11','C11','G11'),sum({<[Company ID]={'E11','A11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','A11','C11','B11'),sum({<[Company ID]={'E11','A11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','A11','G11','B11'),sum({<[Company ID]={'E11','A11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','C11','G11','B11'),sum({<[Company ID]={'E11','C11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','A11','C11'),sum({<[Company ID]={'F11','D11','A11','C11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','A11','G11'),sum({<[Company ID]={'F11','D11','A11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','A11','B11'),sum({<[Company ID]={'F11','D11','A11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','C11','G11'),sum({<[Company ID]={'F11','D11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([Employee Company]),'F11','D11','C11','B11'),sum({<[Company ID]={'F11','D11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','G11','B11'),sum({<[Company ID]={'F11','D11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','A11','C11','G11'),sum({<[Company ID]={'F11','A11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','A11','C11','B11'),sum({<[Company ID]={'F11','A11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','A11','G11','B11'),sum({<[Company ID]={'F11','A11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','C11','G11','B11'),sum({<[Company ID]={'F11','C11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'D11','A11','C11','G11'),sum({<[Company ID]={'D11','A11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'D11','A11','C11','B11'),sum({<[Company ID]={'D11','A11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'D11','A11','G11','B11'),sum({<[Company ID]={'D11','A11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'D11','C11','G11','B11'),sum({<[Company ID]={'D11','C11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'A11','C11','G11','B11'),sum({<[Company ID]={'A11','C11','G11','B11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'E11','F11','D11'),sum({<[Company ID]={'E11','F11','D11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','A11'),sum({<[Company ID]={'E11','F11','A11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','C11'),sum({<[Company ID]={'E11','F11','C11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','F11','G11'),sum({<[Company ID]={'E11','F11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([Employee Company]),'E11','F11','B11'),sum({<[Company ID]={'E11','F11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','D11','A11'),sum({<[Company ID]={'E11','D11','A11'}>}[Sales  Revenue]),if(match(GetFieldSelections([Employee Company]),'E11','D11','C11'),sum({<[Company ID]={'E11','D11','C11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','D11','G11'),sum({<[Company ID]={'E11','D11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','D11','B11'),sum({<[Company ID]={'E11','D11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','A11','C11'),sum({<[Company ID]={'E11','A11','C11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','A11','G11'),sum({<[Company ID]={'E11','A11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','A11','B11'),sum({<[Company ID]={'E11','A11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','C11','G11'),sum({<[Company ID]={'E11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','C11','B11'),sum({<[Company ID]={'E11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'E11','G11','B11'),sum({<[Company ID]={'E11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','A11'),sum({<[Company ID]={'F11','D11','A11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','C11'),sum({<[Company ID]={'F11','D11','C11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','G11'),sum({<[Company ID]={'F11','D11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','D11','B11'),sum({<[Company ID]={'F11','D11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','A11','C11'),sum({<[Company ID]={'F11','A11','C11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','A11','G11'),sum({<[Company ID]={'F11','A11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','A11','B11'),sum({<[Company ID]={'F11','A11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','C11','G11'),sum({<[Company ID]={'F11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','C11','B11'),sum({<[Company ID]={'F11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'F11','G11','B11'),sum({<[Company ID]={'F11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'D11','A11','C11'),sum({<[Company ID]={'D11','A11','C11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'D11','A11','G11'),sum({<[Company ID]={'D11','A11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'D11','A11','B11'),sum({<[Company ID]={'D11','A11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'D11','C11','G11'),sum({<[Company ID]={'D11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'D11','C11','B11'),sum({<[Company ID]={'D11','C11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'D11','G11','B11'),sum({<[Company ID]={'D11','G11','B11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'A11','C11','G11'),sum({<[Company ID]={'A11','C11','G11'}>}[Sales  Revenue]),if(match(GetFieldSelections([EmployeeCompany]),'A11','C11','B11'),sum({<[Company ID]={'A11','C11','B11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'A11','G11','B11'),sum({<[Company ID]={'A11','G11','B11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'C11','G11','B11'),sum({<[Company ID]={'C11','G11','B11'}>}[Sales  Revenue]),

if(match(GetFieldSelections([Employee Company]),'E11','F11'),sum({<[Company ID]={'E11','F11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'E11','D11'),sum({<[Company ID]={'E11','D11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'E11','A11'),sum({<[Company ID]={'E11','A11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'E11','C11'),sum({<[Company ID]={'E11','C11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'E11','G11'),sum({<[Company ID]={'E11','G11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'E11','B11'),sum({<[Company ID]={'E11','B11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'F11','D11'),sum({<[Company ID]={'F11','D11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'F11','A11'),sum({<[Company ID]={'F11','A11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'F11','C11'),sum({<[Company ID]={'F11','C11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'F11','G11'),sum({<[Company ID]={'F11','G11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'F11','B11'),sum({<[Company ID]={'F11','B11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'D11','A11'),sum({<[Company ID]={'D11','A11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'D11','C11'),sum({<[Company ID]={'D11','C11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'D11','G11'),sum({<[Company ID]={'D11','G11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'D11','B11'),sum({<[Company ID]={'D11','B11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'A11','C11'),sum({<[Company ID]={'A11','C11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'A11','G11'),sum({<[Company ID]={'A11','G11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'A11','B11'),sum({<[Company ID]={'A11','B11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'C11','G11'),sum({<[Company ID]={'C11','G11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'C11','B11'),sum({<[Company ID]={'C11','B11'}>}[Sales  Revenue]),
if(match(GetFieldSelections([Employee Company]),'G11','B11'),sum({<[Company ID]={'G11','B11'}>}[Sales  Revenue])

))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
topic Nested IF statment limit, need an alternitave in QlikView

Nested IF statment limit, need an alternitave
