Nested if logic help please !

Wed, 25 Nov 2020 16:16:04 GMT

I have the below logic ,but I am not sure how to put this together.The bold one's are the new ones I need to add to the already existing logic.Not sure how I can add that within multiple if's.Any help is highly appreciated.

if(AB1OccupancyCount =0 ,

if(AB1BuildingCpacity >= 0 ,

if([AB1BuildingCpacity(Manual)]= 0 , sum([AB1BuildingCpacity]),SUM([AB1BuildingCpacity(Manual)]))))

else

if(AB1OccupancyCount >0 ,

if(AB1BuildingCpacity > 0 ,

( IF(Seats-((count(if(len([EM EmpName])=0,

IF([RoomTypeAssigned]='OFFICE',

UniqueAB2Key)))

count(if(len([EM EmpName])=0,

IF([RoomTypeAssigned]='WRKST',

UniqueAB2Key))))) = 0

or COUNT(distinct (UniqueAB2Key)) =0,

sum([AB1BuildingCpacity(Manual)]),

COUNT(distinct (UniqueAB2Key))))

Thanks

Alva.

Re: Nested if logic help please !

amayuresh — Mon, 28 Mar 2016 03:23:27 GMT

Please provide sample data and expected output

topic Re: Nested if logic help please ! in QlikView

Nested if logic help please !

Re: Nested if logic help please !