Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table with list of filter based values

Hello, I need a Help!!!

I have a database similar to that exemplified below

   

user filtersforced on the set analysislist
LINEYEAR-WEEKNAME_TV
XPTO16-30CAMPANHA1
XPTO16-31CAMPANHA2
XYZ16-32CAMPANHA3
XYZ16-32CAMPANHA4
XYZ16-32CAMPANHA5

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.

3 Replies
marcus_sommer

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

- Marcus

Not applicable
Author

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.


QV - CLAQUETES CONCATENADAS.jpg


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