topic Need help with an expression in QlikView

Need help with an expression

Thu, 19 Apr 2012 17:28:38 GMT

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

GetSelectedCount(C) >1

GetSelectedCount(B) >1

GetSelectedCount(A) >1

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

Thanks,

Tutan

Need help with an expression

CELAMBARASAN — Thu, 19 Apr 2012 17:34:52 GMT

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

Need help with an expression

jonathandienst — Thu, 19 Apr 2012 17:56:22 GMT

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