topic Re: Macro to select a field in QlikView

Macro to select a field

Wed, 25 Nov 2020 16:16:04 GMT

I would like to write a macro to select a field -> currency. I have it written in the following, I know it is wrong, but just to give an ideal what I tend to achieve.

Sub SelectField
rem ActiveDocument.Fields(Currency).Select
Activedocument.getfield("Currency")
End Sub

I am trying to turn on/off the green light button of currency by Marco VBAscript once it is run.

Re: Macro to select a field

Frank_Hartmann — Fri, 21 Oct 2016 16:26:02 GMT

try like:

Sub SelectField

ActiveDocument.Fields("Currency").select "USD"
End Sub

This will set the Filter to "USD"

hope this helps!

Re: Macro to select a field

Fri, 21 Oct 2016 16:35:00 GMT

Thanks, can I do de-select as well?

Re: Macro to select a field

Frank_Hartmann — Fri, 21 Oct 2016 17:27:39 GMT

try like below:

Sub Unselect
ActiveDocument.Fields("Currency").clear
End sub

hope this helps!