Table with list of filter based values

[#1]

Hello, I need a Help!!!

I have a database similar to that exemplified below

user filters	forced on the set analysis	list
LINE	YEAR-WEEK	NAME_TV
XPTO	16-30	CAMPANHA1
XPTO	16-31	CAMPANHA2
XYZ	16-32	CAMPANHA3
XYZ	16-32	CAMPANHA4
XYZ	16-32	CAMPANHA5

I tried the following functions

	ONLY({<
			SEMANA_ANO=,
			MES=,
			MES_ANO=,
			NOME_CLIENTE=,
			CATEGORIA_CLIENTE=,
			SIGLA_UF=,
			ANO=,
			SEMANA_ANO = {'16-32'}
			>} VERSAO_MIDIA)

	MaxString({<
			SEMANA_ANO=,
			MES=,
			MES_ANO=,
			NOME_CLIENTE=,
			CATEGORIA_CLIENTE=,
			SIGLA_UF=,
			ANO=,
			SEMANA_ANO = {'16-32'}
			>} VERSAO_MIDIA)

But without success, when one has more than one NAME_TV for YEAR_WEEK.

Is there any way of using SetAnalysis return more than one value in the list, like a VLOOKUP ?

TKS.

[marcus_sommer]

You could use concat() instead of max() or only().

- Marcus

[#3]

Marcus, Thanks for answering.

I tried using the concat , but as I use a table chart , 3 records are in the same line , what I need is that the table shows the 3 information on a home line.

It was to show 3 lines: GOIGO ANTECELULITE , GOIGO CLAUDIA RAIA and GOIGO MEDICAMENTOSO. Each with their appropriate information .

I tried to put the " VERSÃO" as a dimension , but must force the YEAR_WEEK filter and not let as a screen filter.

[marcus_sommer]

I don't understand your requirement. Why returning more than one value but displaying them separate? I think you could simply use "VERSÃO" as dimension and your expressions may contain your conditions.

- Marcus