Convert if statement to set analysis in qlikview?

[gireesh1216]

Hi All,

My if statement is as follows:

IF(ISNULL(A),'No Receive Date',IF(B<>'Accepted',IF(LEN(C)>0,IF( LEN([D)>0, IF(D>C,'Delayed','On Time'),IF(NOW()-C<0,'On Time','Delayed')),'No Due Date'),'No Action')) as DELAYED

I am looking out for other options instead of using IF statement .

Please  suggest me.

[sushil353]

Why don't you try to put the condition at SQL level

[sushil353]

There you would have more tuning options.

[gireesh1216]

I am getting data from share point not database.

[gireesh1216]

Thank you all