List box using text search in set analysis

[canmarroig]

Hi, I want to create a list box where i want to list only some values using set analyis in searching text. I've tried to use concat since Maxstring gives me only 1 value, i need a list of value,

=concat({<Code={"AB/123/1_G*"},Dimension1={'80'}>} Code,'')

but i don't obtain what i need.

Can you help me?

[antoniotiman · Accepted solution]

Hi Anna,

Try like this

=Aggr(Only({<Code={"=Left(Code,10) ='AB/123/1_G'"},Dimension1={'80'}>} Code),Code)

Regards,

Antonio

[canmarroig]

Thank you Antonio, i know there was something i missed.