topic Re: Qlikview Macro - Field Value into a Variable in QlikView

Qlikview Macro - Field Value into a Variable

Mon, 12 Sep 2016 15:54:39 GMT

Hi,

I have a requirement where I have

1. to get the Selected Field Value in a variable

2. Add a text to the variable

3. Store this content into a new variable

4. Clear all the field values selected.

Sub Var_Test

Set sel_val = ActiveDocument.Fields("Country").GetSelectedValues
v= sel_val.Item(0).Text &", All Countries"
msgbox(v)
ActiveDocument.Variables("vTargetSpecies").SetContent v, true
ActiveDocument.Fields("Country").Clear

End Sub

The Macro is failing when being called. Can you please suggest me on this.

Thanks,

Venu

Re: Qlikview Macro - Field Value into a Variable

Mon, 12 Sep 2016 20:27:49 GMT

Hi,

Your macro works. Make sure value is selected in the Listbox. The variable must be defined as well before macro is executed.

BR,

Kuba

Re: Qlikview Macro - Field Value into a Variable

Anil_Babu_Samineni — Tue, 13 Sep 2016 08:34:24 GMT

Might be problem in your script. Try this

v= sel_val.Item(0).Text & "All Countries"

Re: Qlikview Macro - Field Value into a Variable

Tue, 13 Sep 2016 16:05:41 GMT

Hey,

I tested his macro and it works just fine. It only fails in two situations:

1) Variable is not defined

2) No Country is selected.

BR,

Kuba