topic Re: How to display new field in UI without adding manually? in QlikView

How to display new field in UI without adding manually?

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to display new filed in UI without adding manually like if i use '*' in load statement, i will load new filed into application whenever added in database however, how to get same field into UI (like table chart) without adding manually.

Thanks,

Nihhal.

Re: How to display new field in UI without adding manually?

swuehl — Sun, 12 Feb 2017 13:37:47 GMT

You can use the system field $Field to list all available fields in the data model.

You can also select in this field and use the selection in your charts.

Re: How to display new field in UI without adding manually?

nihhalmca — Sun, 12 Feb 2017 13:57:07 GMT

Hi Stefan, could you please attach sample qvw.

I could not understand.

Re: How to display new field in UI without adding manually?

vinieme12 — Sun, 12 Feb 2017 14:32:59 GMT

create listbox >> in FieldList Select "<Expression>" >> add expression $Field

This will give you a list of ALL FieldNames in your App

to show fields only from a particular table use below expression

=AGGR(only({<$Table = {'TABLENAME'}>}$Field),$Field)

Re: How to display new field in UI without adding manually?

swuehl — Sun, 12 Feb 2017 16:46:08 GMT

Here is an example.

The $Field list box is built upon the system field $Field. If you select a value / field name, the charts can adapt to the selection.

Re: How to display new field in UI without adding manually?

nihhalmca — Fri, 03 Mar 2017 08:44:01 GMT

Thanks Stefan.

Re: How to display new field in UI without adding manually?

nihhalmca — Wed, 21 Jun 2017 08:34:48 GMT

Hi Stefan,

How can i show more than one field in chart as per your example.