Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
bill_markham

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, ', ')

View solution in original post

Not applicable

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!

bill_markham
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

Hi Bill

you can use GetFieldSelections(Fieldname)

best regards

Chris