Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor III

Boolean expression for field value = field value + 1

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

2 Replies
Highlighted
Honored Contributor III

Re: Boolean expression for field value = field value + 1

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

Highlighted
New Contributor III

Re: Boolean expression for field value = field value + 1

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