topic Re: How to get the possible value from list box in QlikView

How to get the possible value from list box

Fri, 31 Aug 2012 11:39:43 GMT

Hi all,

Here I want to get 102 from ID field.

Is any way to solve this?

Thanks in advance..

Regards,

Kabilan K.

Re: How to get the possible value from list box

Gethyn — Fri, 31 Aug 2012 11:57:39 GMT

HI Kabilan,

Create a macro like this one:

Sub SelectPossibleID()

Dim strvID

Set vID = ActiveDocument.Fields("ID").GetPossibleValues

strvID = vID.item(i).Text

End Sub

Then set a sheet trigger to run the macro on selecting a value in the Name field. This will then write the possible value from the ID field to a variable named strvID.

Hope this helps,

Gethyn.

Re: How to get the possible value from list box

jonathandienst — Fri, 31 Aug 2012 12:17:28 GMT

You can do this in an expression (for example, in a text box) with

=Concat(ID, ',')

This will return a comma separated list of possible values for ID.

Regards

Jonathan

Re: How to get the possible value from list box

Fri, 31 Aug 2012 12:38:00 GMT

Hi Gethyn,

I have a doubt.

In that macro, we have variable called StrvID and How to get this variable in text object and (Expression dialog box)?

Regards,

Kabilan K.

Re: How to get the possible value from list box

Gethyn — Fri, 31 Aug 2012 12:51:58 GMT

Hi Kabilan,

You can show the value in a text box by typing =strvID as the value in the text box.

Thanks,

Gethyn.

Re: How to get the possible value from list box

Fri, 31 Aug 2012 13:26:27 GMT

Hi Gethyn,

I wrote the macro and applied in fileld event trigger for Name field.

But I am not able to see that variable ( =strvID) in variable list.

Regards,

Kabilan K.