topic Re: Multiple if's logic help please. in QlikView

Multiple if's logic help please.

Wed, 25 Nov 2020 16:16:04 GMT

I need to put the below logic together.How can I do that please ?

Building ID	Occupancy Count	Building Capacity	Occupancy Count (manual)	Building Capacity (manual)
THOM-B0843	0	2	0	0
BUCHAREST	0	1	0	0
THOM-B5661	0	256	0	0
BLACKWALL	0	1	0	0
THOM-B0150-M	0	2	0	0
THOM-B5631	0	35	0	0
KUWAIT	0	14	0	0
THOM-B4032	0	6	0	0
THOM-B5262	0	96	0	0
SAUCES	0	22	0	0
THOM-1234	0	34	67	100
THOM-3218	0	45	67	108

if ([Occupancy count] =0 ,

if([Building Capacity] > 1 , sum([Building Capacity(Manual)]

the tricky part is if the first rule is true and

if([Building Capacity(Manual)] =0 ,

if([Occupancy Count(Manual)]=0,sum([Building Capacity]

Thanks much,

Alva

Re: Multiple if's logic help please.

amayuresh — Mon, 28 Mar 2016 03:35:31 GMT

Do you want expression like this

=if ([Occupancy Count]=0 and [Building Capacity (manual)] =0 and [Occupancy Count (manual)]=0,sum([Building Capacity]),

if ([Occupancy Count] <>0 and [Building Capacity] > 1 , sum([Building Capacity (manual)])))

or can elaborate your requirement more with example

Re: Multiple if's logic help please.

ahammadshafi — Mon, 28 Mar 2016 03:58:27 GMT

Hi Pavana:

May be this will work

If([Occupancy Count]=0 and [Building Capacity(Manual)] = 0 and [Occupancy Count(Manual)] = 0, Sum([Building Capacity]),

If ([Occupancy Count]=0 and [Building Capacity]>1), Sum([Building Capacity(Manual)]))

Re: Multiple if's logic help please.

ahammadshafi — Mon, 28 Mar 2016 04:00:19 GMT

Hi Pavana:

You can try this if the first one doesn't work

If([Occupancy Count]=0 and [Building Capacity(Manual)] = 0 and [Occupancy Count(Manual)] = 0 and [Building Capacity]<2, Sum([Building Capacity]),

If ([Occupancy Count]=0 and [Building Capacity]>1), Sum([Building Capacity(Manual)])

Re: Multiple if's logic help please.

amayuresh — Mon, 28 Mar 2016 04:20:19 GMT

there few brackets are missing. Check this now,

=If([Occupancy Count]=0 and [Building Capacity (manual)] = 0 and [Occupancy Count (manual)] = 0 and [Building Capacity]<2, Sum([Building Capacity]),

If([Occupancy Count]=0 and [Building Capacity]>1, Sum([Building Capacity (manual)])))

This works for me.

Re: Multiple if's logic help please.

ahammadshafi — Mon, 28 Mar 2016 05:29:58 GMT

Many thanks Mayuresh.

Apologies for the mistake. Just copying from Mayuresh:

=If([Occupancy Count]=0 and [Building Capacity (manual)] = 0 and [Occupancy Count (manual)] = 0 and [Building Capacity]<2, Sum([Building Capacity]),

If([Occupancy Count]=0 and [Building Capacity]>1, Sum([Building Capacity (manual)])))

Re: Multiple if's logic help please.

avinashelite — Mon, 28 Mar 2016 05:36:29 GMT

Try like this

if ([Occupancy count] =0 and [Building Capacity] > 1 and [Building Capacity(Manual)] =0 and [Occupancy Count(Manual)]=0, sum([Building Capacity(Manual)],

if([Building Capacity(Manual)] =0 and [Occupancy Count(Manual)]=0,sum([Building Capacity]

)