Need help with an expression

[#1]

Hi All,

I need a help with an expression to understand what it does, I am absolutely new to QlikView. This expression is written in a text object.

=isnull(GetFieldSelection(A))

+

isnull(GetFieldSelection(B))

+

isnull(Get FieldSelection(C)) <> -2

or

GetSelectedCount(C) >1

or

GetSelectedCount(B) >1

or

GetSelectedCount(A) >1

Here A, B. C are list boxes where we have string data. Pls help.

Thanks,

Tutan

[CELAMBARASAN · Accepted solution]

Hi,

     IsNull() returns -1(normally known as true) or 0(normally known as false) based on the given expression inside it returns null or not null(if null returns -1 else 0)

     OR and AND conditions between expression also returns 0 or -1.

Celambarasan

[jonathandienst]

Tutan

If I'm not mistaken, the expression returns true (-1) or false (0) based on either

     a selection in exactly 1 of the list boxes

     multiple selections in any of the list boxes

Regards

Jonathan