Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Get Possible Values for a Field

Maybe

=concat(fieldname, ', ')

5 Replies
MVP
MVP

Re: Get Possible Values for a Field

Maybe

=concat(fieldname, ', ')

Not applicable

Re: Get Possible Values for a Field

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
Valued Contributor II

Re: Get Possible Values for a Field

Try this:

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

Hope this helps!

Re: Get Possible Values for a Field

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

Re: Get Possible Values for a Field

Hi Bill

you can use GetFieldSelections(Fieldname)

best regards

Chris