topic Re: Mistake in condition syntax VBS macro in QlikView

Mistake in condition syntax VBS macro

Peony — Wed, 25 Nov 2020 16:16:04 GMT

Hi all.

There is some macro example. It should works on field click and send message foruser depending which value was selected. But instead of macro running I recive message "Macro parce failed. functionality was lost". What's wrong with it's functionality?

sub notification

set vTOP = ActiveDocument.Fields("TOP").GetSelectedValues

if

$(vTOP) = 20

then MsgBox "It's 20!"

else MsgBox "Not 20"

end if

end sub

Re: Mistake in condition syntax VBS macro

m_woolf — Mon, 27 Nov 2017 14:36:08 GMT

There is no dollar-sign expansion in VBS.

This is from the API Guide:

set val=ActiveDocument.Fields("Month").GetSelectedValues

for i=0 to val.Count-1

msgbox(val.Item(i).Text)

Re: Mistake in condition syntax VBS macro

Peony — Mon, 27 Nov 2017 15:20:37 GMT

Thank you. It helps.