Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is possible to add calculated dimension with Set Analisys?

Always i have a doubt.....when i use calculated dimension.....can i use set analisys?

for example......i can replace for example

=IF(CD_SETOR_ATENDIMENTO = 37,NM_EXAME)

to something like this:

=Only({$<CD_SETOR_ATENDIMENTO = {37}>} NM_EXAME) (Don´t work)

Anyone have some idea???

tks a lot!!!!



2 Replies
fernandotoledo
Partner - Specialist
Partner - Specialist

Yes, you can, but to do a calculated dimension this way you must use AGGR(), like

AGGR( only($(CATEGORY={'32'},PRODUCT), PRODUCT)


Not applicable
Author

I try to use AGGR by your syntax, but still doens´t work!!!!