expression in a textbox

[#1]

Hi,

I am trying to load text string in a textbox using an expression.Not sure why this is not working. If I try the same expression in a table chart it is working.Can anyone please help.My expression is = if(MeasureName='Occupancy',Narrative). Narrative is the field from where I am pulling text string.Columns in tha table are : MeasureName,Narrative,Entered By, Entered Month

Thanks Mridula

[#2]

Hi,

You could try this

if(only(MeasureName)='Occupancy',Narrative)

[CELAMBARASAN · Accepted solution]

Is MeasureName Field gets selected? Becuase in textbox if condition will work only if one MeasureName is selected

You could use

Only({<MeasureName={'Occupancy'}>} Narrative)

Or

MaxString({<MeasureName={'Occupancy'}>} Narrative)

Or

MinString({<MeasureName={'Occupancy'}>} Narrative)

[tresesco]

This is because there would be many records, and in text box you are not using any aggregation function. Select one MeasureName and you would see something in the text if you put an expression like:

=if(MeasureName='Occupancy',Narrative, 'No Occupancy')

[MayilVahanan]

Hi

If you select the 'Occupancy' in MeasureName field, the number of possible values in Narrative field is only one, then its display that value in text object, otherwise it display '-' (Null).

Its work like only() function.

You can use like Concat(Distinct Narrative, ',') or MaxString(Narrative) like wise.
Or May be you can use Aggr() function also. Its depend on requirement.

[#6]

Perfect ! Thank you Mayil. It worked.

[#7]

Thanks. THis solution worked for me.