ALT function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: ALT function

sunny_talwar — Fri, 11 Nov 2016 14:08:16 GMT

May be like this:

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

If(A3=A2,

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