Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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 II
Champion II

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)

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.