topic Re: if value is '0' then call another value??? in QlikView

???

xyz1 — Sun, 14 Apr 2019 11:26:19 GMT

hemanthaanichet — Fri, 27 Jan 2017 04:02:46 GMT

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

hemanthaanichet — Fri, 27 Jan 2017 04:04:52 GMT

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

xyz1 — Sun, 14 Apr 2019 17:19:01 GMT

hemanthaanichet — Fri, 27 Jan 2017 04:10:10 GMT

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

if possible can you share the error

xyz1 — Sun, 14 Apr 2019 17:18:25 GMT

hemanthaanichet — Fri, 27 Jan 2017 04:19:13 GMT

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 — Fri, 27 Jan 2017 07:03:44 GMT

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

Regards,

Murali Mohan.T

satheshreddy — Fri, 27 Jan 2017 07:15:21 GMT

Hi Sharma,

try once the below Exp.

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

Regards

Sathish