topic Re: Alternate State and Excluded in QlikView https://community.qlik.com/t5/QlikView/Alternate-State-and-Excluded/m-p/492942#M482385 <HTML><HEAD></HEAD><BODY><P>Understand!</P><P>[<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">FieldName</SPAN>]=e({$+<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">AlternateState</SPAN>}::<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">FieldName</SPAN>).</P></BODY></HTML> Thu, 15 Aug 2013 05:15:45 GMT 2013-08-15T05:15:45Z Alternate State and Excluded https://community.qlik.com/t5/QlikView/Alternate-State-and-Excluded/m-p/492941#M482384 <HTML><HEAD></HEAD><BODY><P>Hello! Now I have this expression:</P><P>[FieldName]={*}-{$(=Concat({$+AlternateState}'['&amp;FieldName&amp;']',','))} - all value excluded selected in two states.</P><P>how i can write this another way? Because it's slowly work<SPAN style="font-size: 10pt;">.</SPAN></P><P><SPAN style="font-size: 10pt;">For one alternate state may be </SPAN></P><P><SPAN style="font-size: 10pt;">[FieldName]={*}-AlternateState::FieldName.</SPAN></P><P><SPAN style="font-size: 10pt;">But for two? {$+AlternateState}?<BR /></SPAN></P></BODY></HTML> Wed, 14 Aug 2013 10:20:44 GMT https://community.qlik.com/t5/QlikView/Alternate-State-and-Excluded/m-p/492941#M482384 2013-08-14T10:20:44Z Re: Alternate State and Excluded https://community.qlik.com/t5/QlikView/Alternate-State-and-Excluded/m-p/492942#M482385 <HTML><HEAD></HEAD><BODY><P>Understand!</P><P>[<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">FieldName</SPAN>]=e({$+<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">AlternateState</SPAN>}::<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">FieldName</SPAN>).</P></BODY></HTML> Thu, 15 Aug 2013 05:15:45 GMT https://community.qlik.com/t5/QlikView/Alternate-State-and-Excluded/m-p/492942#M482385 2013-08-15T05:15:45Z