topic Store list box selection in a variable in QlikView

Store list box selection in a variable

pkelly — Thu, 23 Jul 2009 15:04:50 GMT

I have a list box and I would like to store the selected value(s) is a variable.

I think I have worked out how to get the value from the list box - "ProdFamily" is my list box field.

set prodfamilyselection=ActiveDocument.Fields("ProdFamily").GetSelectedValues

How do I store this in a variable?

Store list box selection in a variable

Thu, 23 Jul 2009 15:23:31 GMT

Hi,

here you are

sub StoreValues

set v = ActiveDocument.Variables("sel")
set doc = ActiveDocument
set mySelections = doc.fields("SW_Temp").GetSelectedValues
sel = chr(39) & mySelections.Item(0).text & chr(39)
for i = 1 to mySelections.Count - 1
sel = sel & chr(44) & chr(39) & mySelections.Item(i).text &chr(39)
next
v.SetContent sel,true

end sub

A QV example follows in a few minutes.

Rainer

Store list box selection in a variable

Thu, 23 Jul 2009 15:37:44 GMT

Hi,

here are the application.

It´s not 100% perfect.

Rainer

Store list box selection in a variable

pkelly — Thu, 23 Jul 2009 15:51:34 GMT

Thanks Rainer - this is excellent and is exactly what I am looking for...

One quick question - in your example, how do you get the "sel" variable to update automatically when a list box selection is made?

Store list box selection in a variable

Thu, 23 Jul 2009 15:52:32 GMT

Please remove the second macro.

Than the application runs without problems.

Rainer

Store list box selection in a variable

Thu, 23 Jul 2009 15:58:39 GMT

Document Properties => Macros

See the screenshot.

Rainer

Store list box selection in a variable

pkelly — Thu, 23 Jul 2009 16:07:37 GMT

Thanks Rainer ... Your solution is exactly what I am looking for...

Store list box selection in a variable

Tue, 29 Sep 2009 19:06:55 GMT

Thanks Rainer.... its really good one ...

Once again Thanks

Store list box selection in a variable

Fri, 20 May 2011 10:54:39 GMT

I am using latest personal edition . I dont see macros Tab in Document properties. Could you help? Again my macros also dont recognize ActiveDocument Object