Populate the expression labels based formula - Qlik Community

Anonymous · ‎2012-10-25

Hi,

I am developing a report where i need to populate the expression labels based formula. Here is the details.

In the chart the expressions are coming from one table, where the names are based on the table from where they come. E.g. MRSH03 is the table name so the field name is MRSH03_EXPOSURE.

But in my report the field names I cant show, and some times the names can varry also. Llike it may be a month. So I have created another table, where I have kept the expression names and the represented name in the report.

Is there any formula so that I can get the expression column name, so that I can map the represented name.

For example, formula in the below highlited field so that the output will be MRSH03_EXPOSURE.

lironbaram · ‎2012-10-25

you can use

maxstring({<DATASHEETFIELDNAME={MRSH03_EXPOSURE}>}REPRESENTED_VALUE)