topic Re: Set Analysis - multiple conditions in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-multiple-conditions/m-p/810346#M1028231 <HTML><HEAD></HEAD><BODY><P>what do you want, allvalues for fiscal year 2015 and all data for what? for all months in 2015?</P><P>or all months including previous fiscal years?</P><P>which dimensions are in your bar Chart?</P></BODY></HTML> Mon, 16 Feb 2015 16:48:25 GMT Anonymous 2015-02-16T16:48:25Z Set Analysis - multiple conditions https://community.qlik.com/t5/QlikView/Set-Analysis-multiple-conditions/m-p/810344#M1028228 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I wonder if anyone can help please...</P><P></P><P>I am trying to use two set analysis in an expression:</P><P><IMG alt="" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/78184_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>They both work separately as expression, however, when I try to combine them they do not both give the desired effect.</P><P>I want to be able to fix the bar chart on FY 2015 as well as fixing the bar chart to display all values.</P><P></P><P>Ie, my bar chart is fixed on FY15 and does not change when months are selected etc.</P><P></P><P></P><P>Many thanks,</P></BODY></HTML> Mon, 16 Feb 2015 09:56:12 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-multiple-conditions/m-p/810344#M1028228 2015-02-16T09:56:12Z Re: Set Analysis - multiple conditions https://community.qlik.com/t5/QlikView/Set-Analysis-multiple-conditions/m-p/810345#M1028229 <HTML><HEAD></HEAD><BODY><P>I'm not exactly clear on what you want, but try sum({1&lt;fYear = {2015}&gt;} [Turnover Value])</P><P></P><P>mike</P></BODY></HTML> Mon, 16 Feb 2015 16:32:05 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-multiple-conditions/m-p/810345#M1028229 mikecrengland 2015-02-16T16:32:05Z Re: Set Analysis - multiple conditions https://community.qlik.com/t5/QlikView/Set-Analysis-multiple-conditions/m-p/810346#M1028231 <HTML><HEAD></HEAD><BODY><P>what do you want, allvalues for fiscal year 2015 and all data for what? for all months in 2015?</P><P>or all months including previous fiscal years?</P><P>which dimensions are in your bar Chart?</P></BODY></HTML> Mon, 16 Feb 2015 16:48:25 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-multiple-conditions/m-p/810346#M1028231 Anonymous 2015-02-16T16:48:25Z Re: Set Analysis - multiple conditions https://community.qlik.com/t5/QlikView/Set-Analysis-multiple-conditions/m-p/810347#M1028233 <HTML><HEAD></HEAD><BODY><P>Mike, Thankyou works perfectly!!!</P></BODY></HTML> Mon, 16 Feb 2015 17:06:15 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-multiple-conditions/m-p/810347#M1028233 2015-02-16T17:06:15Z Re: Set Analysis - multiple conditions https://community.qlik.com/t5/QlikView/Set-Analysis-multiple-conditions/m-p/810348#M1028235 <HTML><HEAD></HEAD><BODY><P>Joe, would you mind to close this discussion by marking Mike's answer as correct? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Mon, 16 Feb 2015 17:21:35 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-multiple-conditions/m-p/810348#M1028235 Anonymous 2015-02-16T17:21:35Z