topic 9.0 Set Analysis Issue? in QlikView https://community.qlik.com/t5/QlikView/9-0-Set-Analysis-Issue/m-p/204896#M61612 <HTML><HEAD></HEAD><BODY><P>In our 8.5 environment, set analysis works great for an expression th</P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">sum({$&lt;[Flag1] = {'0'},</P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">[Type]= {'Revenue'},</P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">[Account] - {'9898'},</P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">[ProfitCenter] = {'Tags'} &gt; } [Amount])</P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;"></P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">Once we installed 9.0 the same expression is not "Exclduing" 9898, as it has done in the past..</P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;"></P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">Is 9.0 using different logic for exclusions?</P><P></P></BODY></HTML> Thu, 07 Jan 2010 22:27:10 GMT james 2010-01-07T22:27:10Z 9.0 Set Analysis Issue? https://community.qlik.com/t5/QlikView/9-0-Set-Analysis-Issue/m-p/204896#M61612 <HTML><HEAD></HEAD><BODY><P>In our 8.5 environment, set analysis works great for an expression th</P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">sum({$&lt;[Flag1] = {'0'},</P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">[Type]= {'Revenue'},</P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">[Account] - {'9898'},</P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">[ProfitCenter] = {'Tags'} &gt; } [Amount])</P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;"></P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">Once we installed 9.0 the same expression is not "Exclduing" 9898, as it has done in the past..</P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;"></P><P style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">Is 9.0 using different logic for exclusions?</P><P></P></BODY></HTML> Thu, 07 Jan 2010 22:27:10 GMT https://community.qlik.com/t5/QlikView/9-0-Set-Analysis-Issue/m-p/204896#M61612 james 2010-01-07T22:27:10Z 9.0 Set Analysis Issue? https://community.qlik.com/t5/QlikView/9-0-Set-Analysis-Issue/m-p/204897#M61613 <HTML><HEAD></HEAD><BODY><P>Are you not missing a = ?</P><P>Account] -= {'9898'},</P></BODY></HTML> Thu, 07 Jan 2010 22:49:27 GMT https://community.qlik.com/t5/QlikView/9-0-Set-Analysis-Issue/m-p/204897#M61613 2010-01-07T22:49:27Z 9.0 Set Analysis Issue? https://community.qlik.com/t5/QlikView/9-0-Set-Analysis-Issue/m-p/204898#M61614 <HTML><HEAD></HEAD><BODY><P>Yes, but in 8.5 that wasnt needed, go figure!<IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P><P>It works</P><P>Thanks!</P></BODY></HTML> Thu, 07 Jan 2010 22:58:25 GMT https://community.qlik.com/t5/QlikView/9-0-Set-Analysis-Issue/m-p/204898#M61614 james 2010-01-07T22:58:25Z