Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz1
Creator III
Creator III

???

.

8 Replies
hemanthaanichet
Creator III
Creator III

if(Late(mm)>=0, Late(mm), Total elapsed time)

hemanthaanichet
Creator III
Creator III

if(len(Late(mm))=0,Total elapsed time,Late(mm))

xyz1
Creator III
Creator III
Author

.

hemanthaanichet
Creator III
Creator III

if(Len([Late (mm)])=0,[Total elapsed time],[Late (mm)])

if possible can you share the error

xyz1
Creator III
Creator III
Author

.

hemanthaanichet
Creator III
Creator III

Sharma i think u copied and pasted that doesnt work

Total Elapsed time it should be like [Total Elapsed Time]  because of spaces in the column name

if u have space  in column name it should be with in the brackets

May be this can work

if(Len([Late (mm)])=0,[Total elapsed time],[Late (mm)])

Anonymous
Not applicable

=if(Late(mm)=0 or null(),[Total elapsed time],Late(mm))

Regards,

Murali Mohan.T

satheshreddy
Creator III
Creator III

Hi Sharma,

try once the below Exp.

=if(isnull(Late(mm)),[Total elapsed time],Late(mm))


Regards

Sathish