Creation of new column with respect previous columns

[babud41]

Hi everyone,

I am trying to create a new column in a table corresponding to previous columns.

Which is if the above all four columns rx_8am, rx_12pm, rx_4pm, rx_8pm is not null then-new column result should be 'YES" or if any one or all are null the result of the new column should be 'NO'.

Here I am attaching the picture for your reference

Kindly help

Thanks.

QlikView 

[AshutoshBhumkar · Accepted solution]

Hello,

One of the ways is to check length of the data.

E.g

If(len(A)>0
and
len(B)>0
and
len(C)>0
and
len(D)>0,'Yes','NO'

)

Check if that works for you.

Thanks,

Ashutosh

[babud41 · Accepted solution]

Hi Ashutosh,

It's working superbly fine now.

Before I stucked with  the bad expression of " if(len(RX_8AM)>0,if(len(RX_12PM)>0,if(len(RX_4PM)>0, if(len(RX_8PM) >0 ,'YES' , 'NO')))) " 

Thanks a lot man once again.

[AshutoshBhumkar]

🙂

Welcome

[AshutoshBhumkar]

Hello, 

Please mark the answer as correct if that solves your problem.

Thanks,

Ashutosh

[babud41]

Hi Ashutosh

I have done.

I am not aware of this before.

Thanks again