ALT function

[Anonymous]

I have an excel sentence:

if(iserror(c3-c2)=TRUE;1; if(A3=A2; if(C3-C2<0.0007;0;1);1)

i have to implement it as a new variable called TimeDisc in qlikview but i don't know how to do it. ¿Maybe with the ALT function?

[sunny_talwar]

May be like this:

If(Len(Trim(c3-c2)) = 0, 1,

     If(A3=A2,

          If(C3-C2 < 0.0007, 0, 1), 1))