topic Checking return for Select in macro in QlikView

Checking return for Select in macro

Fri, 24 Apr 2009 03:45:14 GMT

I want to provide a message if the Select in the macro fails. With the code below, I'm getting the error Expected 'Then', with "District of Columbia" = false then highlighted. Anyone have a suggestion? Thanks.

if ActiveDocument.Fields("STATE_NAME"). Select "District of Columbia" = false then msgbox("Data does not exist for the selected Reporting State.")

end if

Checking return for Select in macro

rwunderlich — Fri, 24 Apr 2009 04:14:05 GMT

To get a return value from Select, you must use the function argument form -- that is, enclose the argument in parens.

if ActiveDocument.Fields("STATE_NAME").Select("District of Columbia") = false then msgbox("Data does not exist for the selected Reporting State.")

Also. if using the single-line syntax If, don't include an End If.

-Rob

Checking return for Select in macro

Fri, 24 Apr 2009 04:15:12 GMT

Sorry, that shouldn't have posted.

Checking return for Select in macro

Fri, 24 Apr 2009 19:35:04 GMT

Rob, that is exactly what I needed. Thanks for your help. Laurie