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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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!!!!