Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thank you!