Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

How to display new field in UI without adding manually?

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.

6 Replies
swuehl
MVP
MVP

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.

nihhalmca
Specialist II
Specialist II
Author

Hi Stefan, could you please attach sample qvw.

I could not understand.

vinieme12
Champion III
Champion III

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)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
swuehl
MVP
MVP

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.

nihhalmca
Specialist II
Specialist II
Author

Thanks Stefan.

nihhalmca
Specialist II
Specialist II
Author

Hi Stefan,

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