Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
xyz1
Contributor III

???

.

8 Replies
hemanthaanichet
Contributor III

Re: if value is '0' then call another value???

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

hemanthaanichet
Contributor III

Re: if value is '0' then call another value???

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

xyz1
Contributor III

?

.

hemanthaanichet
Contributor III

Re: if value is '0' then call another value???

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

if possible can you share the error

xyz1
Contributor III

?

.

hemanthaanichet
Contributor III

Re: if value is '0' then call another value???

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)])

murliqlik
Contributor

Re: if value is '0' then call another value???

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

Regards,

Murali Mohan.T

satheshreddy
Contributor III

Re: if value is '0' then call another value???

Hi Sharma,

try once the below Exp.

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


Regards

Sathish