Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

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
Highlighted
MVP
MVP

Maybe

=concat(fieldname, ', ')

View solution in original post

5 Replies
Highlighted
MVP
MVP

Maybe

=concat(fieldname, ', ')

View solution in original post

Highlighted
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

Highlighted
Specialist II
Specialist II

Try this:

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

Hope this helps!

Highlighted

swuehl

Yup, perfect.

I just need to add the distinct for my scenario.

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

Many Thanks,     Bill

Highlighted
Not applicable

Hi Bill

you can use GetFieldSelections(Fieldname)

best regards

Chris