topic List Box - List all Field Names in QlikView

List Box - List all Field Names

jzimolong — Fri, 24 May 2013 02:30:18 GMT

I did my best to try and find the answer to this, but no luck.

All I want to do is have an input box drop-down, listing all the fields of a single table. I already have a chart dynamically responding to a manual list of fields in a drop-down (list box), but I'd like to get all the fields in the list box without having to type them all out.

Thanks, hopefully this is not redundant.

Re: List Box - List all Field Names

Sokkorn — Fri, 24 May 2013 02:48:39 GMT

Hi,

Try to create one ListBox with Expression =$Field

Regards,

Sokkorn

Re: List Box - List all Field Names

jzimolong — Fri, 24 May 2013 03:04:01 GMT

Thanks Sokkorn, how can I capture the selection of this ListBox in a variable?

Re: List Box - List all Field Names

Sokkorn — Fri, 24 May 2013 05:06:36 GMT

Hi,

Try this vField=GetFieldSelections([$Field])

Regards,

Sokkorn

Re: List Box - List all Field Names

jzimolong — Fri, 24 May 2013 10:38:56 GMT

That does it, thank you again Sokkorn.

Re: List Box - List all Field Names

Sokkorn — Fri, 24 May 2013 10:46:10 GMT

Hi Sir,

You are welcome.

Regards,

Sokkorn