topic Re: Get Possible Values for a Field in QlikView

Get Possible Values for a Field

Anonymous — Fri, 06 Dec 2013 13:52:51 GMT

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

swuehl — Fri, 06 Dec 2013 13:54:33 GMT

Maybe

=concat(fieldname, ', ')

Fri, 06 Dec 2013 13:57:57 GMT

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 — Fri, 06 Dec 2013 14:00:30 GMT

Try this:

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

Hope this helps!

Anonymous — Fri, 06 Dec 2013 14:00:47 GMT

Yup, perfect.

I just need to add the distinct for my scenario.

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

Many Thanks, Bill

Fri, 06 Dec 2013 14:02:05 GMT

Hi Bill

you can use GetFieldSelections(Fieldname)

best regards

Chris