Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

agrimroquette
Valued Contributor

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

i have three fields  

   

NumberTotal elapsed timeLate (mm)
I150925_000156116-
I150925_00015620
I151208_000047167184-
I151208_00004700
I151208_00004700
I160712_0001837319473074
I160712_000183-72984-
I160712_00018300
I160812_0001253942-
I160812_0001251640

i want to call "late(mm)" if its not null or zero then show Total elapse time

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

agrimroquette
Valued Contributor

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

its showing error please help

agrimroquette
Valued Contributor

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

where should i write this??

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

agrimroquette
Valued Contributor

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

Capture.PNG

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