topic Re: If statement help please in QlikView

If statement help please

Wed, 25 Nov 2020 16:16:04 GMT

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

IF([RoomTypeAssigned]='OFFICE',

UniqueAB2Key)))

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

IF([RoomTypeAssigned]='WRKST',

UniqueAB2Key))))) = 0 and if(count(UniqueAB2Key)=0 ,

SUM([AB1OccupancyCount(Manual)])),

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

IF([RoomTypeAssigned]='OFFICE',

UniqueAB2Key)))

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

IF([RoomTypeAssigned]='WRKST',

UniqueAB2Key))))) )

I have the above expression and Once I add 'and if(count(UniqueAB2Key)=0 ' it throws me error.

How can I put that and statement for the first part?

Thank you very much.

Re: If statement help please

sunny_talwar — Thu, 24 Mar 2016 16:20:00 GMT

May be try this:

IF(Seats-((

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

IF([RoomTypeAssigned]='OFFICE',

UniqueAB2Key)))

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

IF([RoomTypeAssigned]='WRKST',

UniqueAB2Key))))) = 0 and count(UniqueAB2Key)=0,

SUM([AB1OccupancyCount(Manual)])),

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

IF([RoomTypeAssigned]='OFFICE',

UniqueAB2Key)))

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

IF([RoomTypeAssigned]='WRKST',

UniqueAB2Key))))) )

Re: If statement help please

Thu, 24 Mar 2016 16:22:05 GMT

Sorry I need or instead of and

Re: If statement help please

Thu, 24 Mar 2016 16:22:20 GMT

Sorry I need or instead of and

Re: If statement help please

Chanty4u — Thu, 24 Mar 2016 16:23:19 GMT

i think that "0" shud nt be there

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

IF([RoomTypeAssigned]='WRKST',

UniqueAB2Key))))) = 0 and if(count(UniqueAB2Key)=0 ,

Re: If statement help please

sunny_talwar — Thu, 24 Mar 2016 16:23:34 GMT

Then replace and with or

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(UniqueAB2Key)=0,

SUM([AB1OccupancyCount(Manual)])),

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

IF([RoomTypeAssigned]='OFFICE',

UniqueAB2Key)))

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

IF([RoomTypeAssigned]='WRKST',

UniqueAB2Key))))) )

Re: If statement help please

sunny_talwar — Thu, 24 Mar 2016 16:25:12 GMT

You can also try this:

=If((Seats - Count({<[EM EmpName] -= {'*'}>}, [RoomTypeAssigned]= {'OFFICE', 'WRKST'}>} UniqueAB2Key)) = 0 or count(UniqueAB2Key) = 0,

(Seats - Count({<[EM EmpName] -= {'*'}>}, [RoomTypeAssigned]= {'OFFICE', 'WRKST'}>} UniqueAB2Key)))

Re: If statement help please

Thu, 24 Mar 2016 16:40:42 GMT

awesome.Thank you as always.