GetSelectedCount

[Anonymous]

Hi,

I need to set a condition:

if any value has been selected in Field Brands (alternate state AS), then 1, else 0.

I can't use the function GetSelectedCount because we're still using an old QlikView version where GetSelectedCount doesn't take {AS} as an argument.

Could you please advise something?

Thank you in advance,

Larisa

[Anonymous · Accepted solution]

Would something like this avoiding the use of GetSelectedCount() help ?

    if ( count( {1} distinct Brand ) > count( {AS} distinct Brand ) , 1 , 0 )

See attached sample qvw.

[Anonymous]

Thank you!