topic Is possible to add calculated dimension with Set Analisys? in QlikView https://community.qlik.com/t5/QlikView/Is-possible-to-add-calculated-dimension-with-Set-Analisys/m-p/180409#M46860 <HTML><HEAD></HEAD><BODY><P>I try to use AGGR by your syntax, but still doens´t work!!!!</P></BODY></HTML> Mon, 30 Aug 2010 19:33:58 GMT 2010-08-30T19:33:58Z Is possible to add calculated dimension with Set Analisys? https://community.qlik.com/t5/QlikView/Is-possible-to-add-calculated-dimension-with-Set-Analisys/m-p/180407#M46858 <HTML><HEAD></HEAD><BODY><P>Always i have a doubt.....when i use calculated dimension.....can i use set analisys?</P><P>for example......i can replace for example</P><P></P><P>=IF(CD_SETOR_ATENDIMENTO = 37,NM_EXAME)</P><P>to something like this:</P><P>=Only({$&lt;CD_SETOR_ATENDIMENTO = {37}&gt;} NM_EXAME) (Don´t work)</P><P></P><P>Anyone have some idea???</P><P></P><P>tks a lot!!!!</P><P></P><DIV></DIV><BR /><BR /></BODY></HTML> Mon, 30 Aug 2010 19:15:41 GMT https://community.qlik.com/t5/QlikView/Is-possible-to-add-calculated-dimension-with-Set-Analisys/m-p/180407#M46858 2010-08-30T19:15:41Z Is possible to add calculated dimension with Set Analisys? https://community.qlik.com/t5/QlikView/Is-possible-to-add-calculated-dimension-with-Set-Analisys/m-p/180408#M46859 <HTML><HEAD></HEAD><BODY><P>Yes, you can, but to do a calculated dimension this way you must use AGGR(), like</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">AGGR( only($(CATEGORY={'32'},PRODUCT), PRODUCT)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 30 Aug 2010 19:21:22 GMT https://community.qlik.com/t5/QlikView/Is-possible-to-add-calculated-dimension-with-Set-Analisys/m-p/180408#M46859 fernandotoledo 2010-08-30T19:21:22Z Is possible to add calculated dimension with Set Analisys? https://community.qlik.com/t5/QlikView/Is-possible-to-add-calculated-dimension-with-Set-Analisys/m-p/180409#M46860 <HTML><HEAD></HEAD><BODY><P>I try to use AGGR by your syntax, but still doens´t work!!!!</P></BODY></HTML> Mon, 30 Aug 2010 19:33:58 GMT https://community.qlik.com/t5/QlikView/Is-possible-to-add-calculated-dimension-with-Set-Analisys/m-p/180409#M46860 2010-08-30T19:33:58Z