Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

Labels (1)
1 Reply
amayuresh
Creator III
Creator III

Please provide sample data and expected output