What means -1 in comparision

[#1]

Hi,

I have the expression:

getSelectedCount(Field_Name), which returns 1 (One value selected).

But if I type getSelectedCount(Field_Name) = 1, it returns -1!

What does that mean?

Thanks!

[Gysbert_Wassenaar · Accepted solution]

-1 means True. 0 is False, any other number then 0 is treated as True.

[Peter_Cammaert]

For a slightly more expanded explanation, see Matematical Constants and Parameter-Free Functions in QV Desktop Help. But only slightly

True and False are dual() values, as is usual in QlikView. You just met the numerical part.

Peter

[SreeniJD]

Hi Angel,

QV returns -1 if condition is true. Wierd but true.

Sreeni

[#5]

Thanks, I thought there should be a reason for that. I'll try to find out.

[Anonymous]

As is oft the case HIC has written a good blog post on this :

     On Boolean Fields and Functions