Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Nested if logic help please !

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.

1 Reply
Highlighted
Creator III
Creator III

Re: Nested if logic help please !

Please provide sample data and expected output