topic Re: Set analysis question in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-question/m-p/434338#M490742 <HTML><HEAD></HEAD><BODY><P>If you're using version 11, you can try using alternate states for this. Set up an alternate state and do set analysis with {$&lt;DIM2={AltState}DIM2&gt;}</P></BODY></HTML> Mon, 24 Sep 2012 14:30:48 GMT danielact 2012-09-24T14:30:48Z Set analysis question https://community.qlik.com/t5/QlikView/Set-analysis-question/m-p/434337#M490741 <HTML><HEAD></HEAD><BODY><P>Hello everyone</P><P></P><P>I have two pivot tables one that has a dimension&nbsp; "DIM1" and the other contains a dimension "DIM2" that is inferior (in hierarchy) to the dimension DIM1. if i filter on the second dimension it filters on DIM1 as well. what i want is for the exppression of the first table not to be affected if I select a value in DIM2. </P><P></P><P>PS: I have already tried&nbsp; to put this in the expression "DIM2=,". but it doesn't work. the fact is If i select a value in DIM2 the other dimensions are affected by this selection as well, do i have to mention all of the dimensions of the app in the expression "DIM2=, DIM3=, DIM4=, DIM5=....etc"</P><P></P><P>Thank you so much in advance</P></BODY></HTML> Mon, 24 Sep 2012 14:20:37 GMT https://community.qlik.com/t5/QlikView/Set-analysis-question/m-p/434337#M490741 2012-09-24T14:20:37Z Re: Set analysis question https://community.qlik.com/t5/QlikView/Set-analysis-question/m-p/434338#M490742 <HTML><HEAD></HEAD><BODY><P>If you're using version 11, you can try using alternate states for this. Set up an alternate state and do set analysis with {$&lt;DIM2={AltState}DIM2&gt;}</P></BODY></HTML> Mon, 24 Sep 2012 14:30:48 GMT https://community.qlik.com/t5/QlikView/Set-analysis-question/m-p/434338#M490742 danielact 2012-09-24T14:30:48Z