topic Applying an alternate state in set analysis : Problem in QlikView https://community.qlik.com/t5/QlikView/Applying-an-alternate-state-in-set-analysis-Problem/m-p/1406854#M459316 <HTML><HEAD></HEAD><BODY><P>I'm having some trouble with a formula that combines set analysis and alternate states.</P><P></P><P></P><P>I'm using a container box, which is set to an alternate state.</P><P></P><P>The regular formula needs to show the #FTE valid for the current month/year.</P><P><STRONG>sum({&lt;Year={$(=Max(Year))}, [Calender.MonthNr]={$(=Max([Calender.MonthNr]))},&nbsp; [KPI Code]={'FTE'}&gt;}[KPI Actuals])</STRONG></P><P></P><P></P><P>Now; the problem is that I have a generic month &amp; year in the report and I want the formula, which is part of of the alternate state, to respond to the proper max month selected.</P><P><SPAN style="font-size: 10pt;">Normally you can override the alternate state with Year= $::Year </SPAN></P><P></P><P>I do not know how to properly apply this is the current situation though.</P><P></P><P><STRONG>sum({&lt;Year={$(=Max(Year<SPAN style="color: #3366ff;">##INDEFAULTSTATE##</SPAN>))}, [Calender.MonthNr]={$(=Max([Calender.MonthNr<SPAN style="color: #3366ff;">##INDEFAULTSTATE##</SPAN>]))},&nbsp; [KPI Code]={'FTE'}&gt;}[KPI Actuals])</STRONG></P><P></P><P></P><P>Anyone know how to properly get this chart to work from the container that is in an alternate state?</P></BODY></HTML> Fri, 06 Oct 2017 09:45:25 GMT markvandermeij7 2017-10-06T09:45:25Z Applying an alternate state in set analysis : Problem https://community.qlik.com/t5/QlikView/Applying-an-alternate-state-in-set-analysis-Problem/m-p/1406854#M459316 <HTML><HEAD></HEAD><BODY><P>I'm having some trouble with a formula that combines set analysis and alternate states.</P><P></P><P></P><P>I'm using a container box, which is set to an alternate state.</P><P></P><P>The regular formula needs to show the #FTE valid for the current month/year.</P><P><STRONG>sum({&lt;Year={$(=Max(Year))}, [Calender.MonthNr]={$(=Max([Calender.MonthNr]))},&nbsp; [KPI Code]={'FTE'}&gt;}[KPI Actuals])</STRONG></P><P></P><P></P><P>Now; the problem is that I have a generic month &amp; year in the report and I want the formula, which is part of of the alternate state, to respond to the proper max month selected.</P><P><SPAN style="font-size: 10pt;">Normally you can override the alternate state with Year= $::Year </SPAN></P><P></P><P>I do not know how to properly apply this is the current situation though.</P><P></P><P><STRONG>sum({&lt;Year={$(=Max(Year<SPAN style="color: #3366ff;">##INDEFAULTSTATE##</SPAN>))}, [Calender.MonthNr]={$(=Max([Calender.MonthNr<SPAN style="color: #3366ff;">##INDEFAULTSTATE##</SPAN>]))},&nbsp; [KPI Code]={'FTE'}&gt;}[KPI Actuals])</STRONG></P><P></P><P></P><P>Anyone know how to properly get this chart to work from the container that is in an alternate state?</P></BODY></HTML> Fri, 06 Oct 2017 09:45:25 GMT https://community.qlik.com/t5/QlikView/Applying-an-alternate-state-in-set-analysis-Problem/m-p/1406854#M459316 markvandermeij7 2017-10-06T09:45:25Z Re: Applying an alternate state in set analysis : Problem https://community.qlik.com/t5/QlikView/Applying-an-alternate-state-in-set-analysis-Problem/m-p/1406855#M459317 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({&lt;Year={$(=Max( <SPAN style="color: #3366ff;">{$}</SPAN> Year))}, [Calender.MonthNr]={$(=Max(<SPAN style="color: #3366ff;">{$}</SPAN>[Calender.MonthNr]))},&nbsp; [KPI Code]={'FTE'}&gt;}[KPI Actuals])</STRONG></P></BODY></HTML> Fri, 06 Oct 2017 09:52:18 GMT https://community.qlik.com/t5/QlikView/Applying-an-alternate-state-in-set-analysis-Problem/m-p/1406855#M459317 tresB 2017-10-06T09:52:18Z Re: Applying an alternate state in set analysis : Problem https://community.qlik.com/t5/QlikView/Applying-an-alternate-state-in-set-analysis-Problem/m-p/1406856#M459318 <HTML><HEAD></HEAD><BODY><P>This is correct ! Thanks you!</P></BODY></HTML> Fri, 06 Oct 2017 09:59:02 GMT https://community.qlik.com/t5/QlikView/Applying-an-alternate-state-in-set-analysis-Problem/m-p/1406856#M459318 markvandermeij7 2017-10-06T09:59:02Z