topic Re: set analysis in Archived Groups https://community.qlik.com/t5/Archived-Groups/set-analysis/m-p/478206#M4217 <HTML><HEAD></HEAD><BODY><P>Tks it is working</P></BODY></HTML> Wed, 16 Oct 2013 16:15:44 GMT upaliwije 2013-10-16T16:15:44Z set analysis https://community.qlik.com/t5/Archived-Groups/set-analysis/m-p/478203#M4214 <HTML><HEAD></HEAD><BODY><P>Ii have pivot table with 3&nbsp; dimensions namely dept,year,region. I want a set expression to calculate sum of sales where dept should remain static and other two dimension shold change as per selections. Pls some help me</P></BODY></HTML> Wed, 23 Jul 2025 14:48:52 GMT https://community.qlik.com/t5/Archived-Groups/set-analysis/m-p/478203#M4214 upaliwije 2025-07-23T14:48:52Z Re: set analysis https://community.qlik.com/t5/Archived-Groups/set-analysis/m-p/478204#M4215 <HTML><HEAD></HEAD><BODY><P>That's not possible if you use dept as a dimension in your pivot table. The easiest fix is to remove dept as dimension from your pivot table and add a listbox with dept as field. Then simply select the dept value you're interested in in the listbox. No set analysis necessary. Or if you do not want to use a listbox you can hardcode the dept in a set analysis expression. Something like sum({&lt;dept={'MyDept1'}&gt;} amount).</P></BODY></HTML> Wed, 16 Oct 2013 14:35:58 GMT https://community.qlik.com/t5/Archived-Groups/set-analysis/m-p/478204#M4215 Gysbert_Wassenaar 2013-10-16T14:35:58Z Re: set analysis https://community.qlik.com/t5/Archived-Groups/set-analysis/m-p/478205#M4216 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>something like:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13819368958951039" jivemacro_uid="_13819368958951039" modifiedtitle="true"> <P>sum({1&lt;year=P(),region=P()&gt;} sales)</P> <P>or</P> <P>sum({&lt;dept=&gt;} sales)</P> </PRE><P></P><P>may help and by the way: this is the wrong group to ask such questions.</P><P></P><P>Regards</P><P>Sven</P></BODY></HTML> Wed, 16 Oct 2013 15:27:40 GMT https://community.qlik.com/t5/Archived-Groups/set-analysis/m-p/478205#M4216 s_uhlig 2013-10-16T15:27:40Z Re: set analysis https://community.qlik.com/t5/Archived-Groups/set-analysis/m-p/478206#M4217 <HTML><HEAD></HEAD><BODY><P>Tks it is working</P></BODY></HTML> Wed, 16 Oct 2013 16:15:44 GMT https://community.qlik.com/t5/Archived-Groups/set-analysis/m-p/478206#M4217 upaliwije 2013-10-16T16:15:44Z