Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
spijatida
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
Digvijay_Singh
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
spijatida
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