topic Easy Alternate State and Set Analysis? in QlikView https://community.qlik.com/t5/QlikView/Easy-Alternate-State-and-Set-Analysis/m-p/831467#M1019305 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">I have a expression in a textbox which works very well with an Alternate State of [AllTheatres]</SPAN><BR /><SPAN style="font-size: 10pt;"><SPAN style="font-size: 10pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">avg</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">aggr</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">count</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">ProcedureCount</SPAN><SPAN style="font-size: 10pt;">), </SPAN><SPAN style="color: #800000; font-size: 10pt;">Weekstart</SPAN><SPAN style="font-size: 10pt;">)) </SPAN></SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Moving over to Set Analysis, I had expected to be able to limit the set to the Alternate State but a text box with a expression of:</SPAN></P><P></P><P>=</P><P></P><P><SPAN style="color: #0000ff; font-size: 10pt;">avg</SPAN><SPAN style="font-size: 10pt;">( {</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">[AllTheatres]</SPAN><SPAN style="font-size: 10pt;">} </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">aggr</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">count</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">ProcedureCount</SPAN><SPAN style="font-size: 10pt;">), </SPAN><SPAN style="color: #800000; font-size: 10pt;">Weekstart</SPAN></P><P><SPAN style="font-size: 10pt;">)) </SPAN></P><P></P><P></P><P></P><P><SPAN style="font-size: 10pt;"> </SPAN></P><P>Gives completely&nbsp; </P><P>differenent results</P><P></P><P>Any ideas?</P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Stewart</SPAN></P></BODY></HTML> Tue, 31 Mar 2015 15:48:20 GMT 2015-03-31T15:48:20Z Easy Alternate State and Set Analysis? https://community.qlik.com/t5/QlikView/Easy-Alternate-State-and-Set-Analysis/m-p/831467#M1019305 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">I have a expression in a textbox which works very well with an Alternate State of [AllTheatres]</SPAN><BR /><SPAN style="font-size: 10pt;"><SPAN style="font-size: 10pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">avg</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">aggr</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">count</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">ProcedureCount</SPAN><SPAN style="font-size: 10pt;">), </SPAN><SPAN style="color: #800000; font-size: 10pt;">Weekstart</SPAN><SPAN style="font-size: 10pt;">)) </SPAN></SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Moving over to Set Analysis, I had expected to be able to limit the set to the Alternate State but a text box with a expression of:</SPAN></P><P></P><P>=</P><P></P><P><SPAN style="color: #0000ff; font-size: 10pt;">avg</SPAN><SPAN style="font-size: 10pt;">( {</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">[AllTheatres]</SPAN><SPAN style="font-size: 10pt;">} </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">aggr</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">count</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">ProcedureCount</SPAN><SPAN style="font-size: 10pt;">), </SPAN><SPAN style="color: #800000; font-size: 10pt;">Weekstart</SPAN></P><P><SPAN style="font-size: 10pt;">)) </SPAN></P><P></P><P></P><P></P><P><SPAN style="font-size: 10pt;"> </SPAN></P><P>Gives completely&nbsp; </P><P>differenent results</P><P></P><P>Any ideas?</P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Stewart</SPAN></P></BODY></HTML> Tue, 31 Mar 2015 15:48:20 GMT https://community.qlik.com/t5/QlikView/Easy-Alternate-State-and-Set-Analysis/m-p/831467#M1019305 2015-03-31T15:48:20Z Re: Easy Alternate State and Set Analysis? https://community.qlik.com/t5/QlikView/Easy-Alternate-State-and-Set-Analysis/m-p/831468#M1019306 <HTML><HEAD></HEAD><BODY><P>you applied state only on the avg</P><P>apply it on count as well</P></BODY></HTML> Tue, 31 Mar 2015 15:50:58 GMT https://community.qlik.com/t5/QlikView/Easy-Alternate-State-and-Set-Analysis/m-p/831468#M1019306 giakoum 2015-03-31T15:50:58Z Re: Easy Alternate State and Set Analysis? https://community.qlik.com/t5/QlikView/Easy-Alternate-State-and-Set-Analysis/m-p/831469#M1019307 <HTML><HEAD></HEAD><BODY><P class="MsoListParagraph" style="margin: 0cm 0cm 10pt 21.75pt; mso-add-space: auto;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">Genius</SPAN>!!</P></BODY></HTML> Tue, 31 Mar 2015 15:55:02 GMT https://community.qlik.com/t5/QlikView/Easy-Alternate-State-and-Set-Analysis/m-p/831469#M1019307 2015-03-31T15:55:02Z