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: 
Anonymous
Not applicable

Get Possible Values for a Field

Hi

Is there a way of getting the Possible Values of a Field.  [Taking into account the effect of selections on associated fields / tables]

As in a bit like GetPossibleCount(fieldname) , but I need the possible values returned not the count.

Best Regards,     Bill

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe

=concat(fieldname, ', ')

View solution in original post

5 Replies
swuehl
MVP
MVP

Maybe

=concat(fieldname, ', ')

Not applicable
Author

Hi Bill,

I used it once to get the values in a listbox ,

But a used it in Macro,

as,

SET ProObject = ActiveDocument.GetSheetObject("Products")

valProduct = ProObject.GetPossibleValues

here "Products" is Chart Id of listbox,

and in valProduct you get the Array of All the Possible Values.

Check if it Helps You in anyway.

Regards,

Ravikant

jerem1234
Specialist II
Specialist II

Try this:

concat({<Field = P(Field)>}distinct Field, ',')

Hope this helps!

Anonymous
Not applicable
Author

swuehl

Yup, perfect.

I just need to add the distinct for my scenario.

     =concat( distinct [Audit Stats Airline IATA Code] , ', ')

Many Thanks,     Bill

Not applicable
Author

Hi Bill

you can use GetFieldSelections(Fieldname)

best regards

Chris