topic How can I get my Set Analysis expression to pick up selections from any field in a Default State? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863310#M302189 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>In a measure I have the following expression:</P><P></P><P>sum({StateA&lt;Year=$::Year&gt;}LineSalesAmount)</P><P></P><P>In this example I have got the expression to select anything from the Year field.</P><P></P><P>How can I get my chart to update based on multiple fields without having to specify it in the expression? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 01 May 2015 14:59:48 GMT jblomqvist 2015-05-01T14:59:48Z How can I get my Set Analysis expression to pick up selections from any field in a Default State? https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863310#M302189 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>In a measure I have the following expression:</P><P></P><P>sum({StateA&lt;Year=$::Year&gt;}LineSalesAmount)</P><P></P><P>In this example I have got the expression to select anything from the Year field.</P><P></P><P>How can I get my chart to update based on multiple fields without having to specify it in the expression? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 01 May 2015 14:59:48 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863310#M302189 jblomqvist 2015-05-01T14:59:48Z Re: How can I get my Set Analysis expression to pick up selections from any field in a Default State? https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863311#M302190 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Like this: sum({$}LineSalesAmount)</SPAN></P></BODY></HTML> Sat, 02 May 2015 09:59:08 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863311#M302190 Gysbert_Wassenaar 2015-05-02T09:59:08Z Re: How can I get my Set Analysis expression to pick up selections from any field in a Default State? https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863312#M302191 <HTML><HEAD></HEAD><BODY><P>Which is the same as sum(LineSalesAmount)</P></BODY></HTML> Sat, 02 May 2015 13:11:38 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863312#M302191 Anonymous 2015-05-02T13:11:38Z Re: How can I get my Set Analysis expression to pick up selections from any field in a Default State? https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863313#M302192 <HTML><HEAD></HEAD><BODY><P>Michael</P><P></P><P>.... unless the expression is within an object with an Alternate State set......</P></BODY></HTML> Sat, 02 May 2015 13:59:07 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863313#M302192 Anonymous 2015-05-02T13:59:07Z Re: How can I get my Set Analysis expression to pick up selections from any field in a Default State? https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863314#M302193 <HTML><HEAD></HEAD><BODY><P>True, thanks Bill. </P></BODY></HTML> Sat, 02 May 2015 14:02:17 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863314#M302193 Anonymous 2015-05-02T14:02:17Z Re: How can I get my Set Analysis expression to pick up selections from any field in a Default State? https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863315#M302194 <HTML><HEAD></HEAD><BODY><P>Not necessarily. See this blog post: <A href="http://qlikboard.com/2012/12/04/set-analysis-alternate-states-quick-tip/" title="http://qlikboard.com/2012/12/04/set-analysis-alternate-states-quick-tip/">Set Analysis &amp; Alternate States – Quick Tip » The Qlik Board!</A>. Perhaps there should be a symbol for the inherited state too. That would allow one to always be explicit about which state should be used.</P></BODY></HTML> Sun, 03 May 2015 07:28:28 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863315#M302194 Gysbert_Wassenaar 2015-05-03T07:28:28Z Re: How can I get my Set Analysis expression to pick up selections from any field in a Default State? https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863316#M302195 <HTML><HEAD></HEAD><BODY><P>Yes, it would be helpful of course.</P></BODY></HTML> Sun, 03 May 2015 15:28:18 GMT https://community.qlik.com/t5/QlikView/How-can-I-get-my-Set-Analysis-expression-to-pick-up-selections/m-p/863316#M302195 Anonymous 2015-05-03T15:28:18Z