topic Multiple Alternate states in set analysis in QlikView https://community.qlik.com/t5/QlikView/Multiple-Alternate-states-in-set-analysis/m-p/1215076#M856505 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Could someone help me in understanding what is wrong with the below expression. I have to use two alternate states for this expression hence alt1 and alt3.</P><P></P><P>=if (GetSelectedCount([Com Service Group])&lt;&gt;0 and GetFieldSelections([ComPeriod]) ='YTD', sum({alt1*alt3&lt;FY_SH20 = {'2017'},Entity_SH20 = {'APAC'},Period_SH20 = {'YTD'}, Month_SH20 = {'Nov'}&gt;}&nbsp; Hours_SH20))</P><P></P><P>Thanks!</P><P>Arun</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Multiple Alternate states in set analysis https://community.qlik.com/t5/QlikView/Multiple-Alternate-states-in-set-analysis/m-p/1215076#M856505 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Could someone help me in understanding what is wrong with the below expression. I have to use two alternate states for this expression hence alt1 and alt3.</P><P></P><P>=if (GetSelectedCount([Com Service Group])&lt;&gt;0 and GetFieldSelections([ComPeriod]) ='YTD', sum({alt1*alt3&lt;FY_SH20 = {'2017'},Entity_SH20 = {'APAC'},Period_SH20 = {'YTD'}, Month_SH20 = {'Nov'}&gt;}&nbsp; Hours_SH20))</P><P></P><P>Thanks!</P><P>Arun</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Multiple-Alternate-states-in-set-analysis/m-p/1215076#M856505 2020-11-25T16:16:04Z Re: Multiple Alternate states in set analysis https://community.qlik.com/t5/QlikView/Multiple-Alternate-states-in-set-analysis/m-p/1215077#M856506 <HTML><HEAD></HEAD><BODY><P>Looks fine to me, what is the issue that you are seeing?</P></BODY></HTML> Sun, 05 Feb 2017 17:34:47 GMT https://community.qlik.com/t5/QlikView/Multiple-Alternate-states-in-set-analysis/m-p/1215077#M856506 sunny_talwar 2017-02-05T17:34:47Z Re: Multiple Alternate states in set analysis https://community.qlik.com/t5/QlikView/Multiple-Alternate-states-in-set-analysis/m-p/1215078#M856507 <HTML><HEAD></HEAD><BODY><P>The expression is not working for for the second alternate state.</P></BODY></HTML> Mon, 06 Feb 2017 03:46:06 GMT https://community.qlik.com/t5/QlikView/Multiple-Alternate-states-in-set-analysis/m-p/1215078#M856507 2017-02-06T03:46:06Z Re: Multiple Alternate states in set analysis https://community.qlik.com/t5/QlikView/Multiple-Alternate-states-in-set-analysis/m-p/1215079#M856509 <HTML><HEAD></HEAD><BODY><P>Unless you elaborate on what is not working, I don't think we will be able offer much help. Try to provide a sample or provide more details</P></BODY></HTML> Mon, 06 Feb 2017 04:21:58 GMT https://community.qlik.com/t5/QlikView/Multiple-Alternate-states-in-set-analysis/m-p/1215079#M856509 sunny_talwar 2017-02-06T04:21:58Z