List Box Expression

[bharatkishore]

Dear All,

I have a field called Name: And in that name i have like 10 subfields and i need to display only 3 subfields in a list box..I have given the following expression..

=if(name ='A1' or name ='A2' or name ='A3',name)

In chart dimension it is working fine but when i take in list box it is not working..Can you please help me how to do it.. i need to filter in only list box..

Regards,

Bharat

[danieloberbilli]

try

=if(match(name,'A1','A2','A3'),name)

[amit_saini]

Bharat,

Two ways:

Script side:

Where match(name,'A1','A2','A3') ;

Front End:

=if(match(name,'A1','A2','A3'),name)

Thanks,

AS

[sagarkharpude]

Better to do in a script as below:

if(match(name,'A1','A2','A3'),name) as Name_New

And use this Name_New field in frontend

[prajapatiamar38 · Accepted solution]

Hi.....

Please find the attached Qvw.

Please Refer the  example.

[jonathandienst]

=Aggr(Only({<name = {'A1', 'A2', 'A3'}>} name), name)

[bharatkishore]

Thanks Amarnath