topic Re: List box using text search in set analysis in QlikView

List box using text search in set analysis

canmarroig — Tue, 27 Jun 2017 09:29:24 GMT

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?

Re: List box using text search in set analysis

antoniotiman — Tue, 27 Jun 2017 09:50:21 GMT

Hi Anna,

Try like this

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

Regards,

Antonio

Re: List box using text search in set analysis

canmarroig — Tue, 27 Jun 2017 10:00:27 GMT

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