topic Re: expression in a textbox in QlikView

expression in a textbox

Fri, 18 Oct 2013 10:27:07 GMT

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

Re: expression in a textbox

Fri, 18 Oct 2013 10:28:48 GMT

Hi,

You could try this

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

Re: expression in a textbox

CELAMBARASAN — Fri, 18 Oct 2013 10:29:40 GMT

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)

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

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

Re: expression in a textbox

tresB — Fri, 18 Oct 2013 10:31:54 GMT

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')

Re: expression in a textbox

MayilVahanan — Fri, 18 Oct 2013 10:33:01 GMT

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.

Re: expression in a textbox

Fri, 18 Oct 2013 10:38:11 GMT

Perfect ! Thank you Mayil. It worked.

Re: expression in a textbox

Fri, 18 Oct 2013 11:00:09 GMT

Thanks. THis solution worked for me.