If statement in two database fields, it is possible?

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

Hello everyone,

I need to compare two field, basically:

if(Today()-FIELD1> FIELD2, 'wrong',
If(Today()-FIELD1> FIELD2, 'correct')) as THEFIELD;

but it is not working, if this can be possible, someone can explain how is the structure? LOAD/Resident etc....

in case of one field, works, but two no.

Thanks!

Re: If statement in two database fields, it is possible?

petter — Tue, 28 Jan 2020 17:27:22 GMT

it seems to me that you should make the expression like this:

Hello everyone,

I need to compare two field, basically:

if(Today()-FIELD1> FIELD2, 'wrong', 'correct') as THEFIELD;

topic If statement in two database fields, it is possible? in QlikView

If statement in two database fields, it is possible?

Re: If statement in two database fields, it is possible?