Multiple if's not working as expected

[dseelam]

Hello Qlik Folks,

Why can't I write multiple if's like this, only 1st statement is working as expected.

if(len(trim([Begin Date]))=0 and len(trim([End Date]))=0, 'Closeouts','Excl Closeout'),
if(len(trim([Begin Date]))>0 and len(trim([End Date]))>0, 'Closeouts','Excl Closeout')
as CloseoutDesc

expected output attached  

[m_woolf]

Unless I'm missing something, your second IF is exactly the same as the first and will never be executed.

Try:

if(len(trim([Begin Date]))=0 and len(trim([End Date]))=0, 'Closeouts','Excl Closeout') as CloseoutDesc

[mrybalko · Accepted solution]

You should write nested ifs like this:

if(condition 1, true,
   if(condition 2, true, false)) as field1

Your case

if(
     (len(trim([Begin Date]))=0 and len(trim([End Date]))=0) // 1 condition
     OR 
     (len(trim([Begin Date]))>0 and len(trim([End Date]))>0), // 2 condition
'Closeouts','Excl Closeout') as CloseoutDesc

 also you can use >= operator and simplify if

if(len(trim([Begin Date]))>=0 and len(trim([End Date]))>=0,  'Closeouts','Excl Closeout') as CloseoutDesc

[dseelam]

difference > & = to signs on both the if's

[dseelam]

Awesome this is what am exactly looking for