topic Re: Boolean expression for field value = field value + 1 in QlikView

Boolean expression for field value = field value + 1

Anonymous — Fri, 23 Feb 2018 18:27:28 GMT

Hello Everybody,

i'm trying to figure out a Boolean expression that checks if a field got a new entry.

Sort of field = field +1

I'm trying right nowto achieve this with:

if(field=field+1,-1.0) .

Of course it's not that easy. Lol.

Anybody who can help me here?

Cheers

spijatida

Digvijay_Singh — Fri, 23 Feb 2018 18:39:01 GMT

Are you trying to check in load statement that the current row field value is same as previous row value or not?

If Yes, then may be something like this, used strings as of now just for readability -

if(field=previous(field),'OldEntry','NewEntry') as Somefield

Anonymous — Fri, 23 Feb 2018 18:51:57 GMT

Actually I try to use that in the condition field when creating alerts