Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get the possible value from list box

Hi all,

Capture1.PNG

Here I want to get 102 from ID field.

Is any way to solve this?

Thanks in advance..  

Regards,

Kabilan K.

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

5 Replies
Gethyn
Creator
Creator

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.

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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.

Gethyn
Creator
Creator

Hi Kabilan,

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

Thanks,

Gethyn.

Not applicable
Author

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.