topic Comparative Analysis Alternate State Aggr Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Comparative-Analysis-Alternate-State-Aggr-Set-Analysis/m-p/1416696#M805100 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the attached Document which looks at the spreadsheet "Transactions.xlsx", I am trying to do the Alternate States using the CustomerNo field but the chart is not changing, the expressions within the chart using Set Analysis and AGGR so I'm not sure if my syntax is right?</P><P></P><P>Anyone know how to do this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT ivandrago 2020-11-25T16:16:04Z Comparative Analysis Alternate State Aggr Set Analysis https://community.qlik.com/t5/QlikView/Comparative-Analysis-Alternate-State-Aggr-Set-Analysis/m-p/1416696#M805100 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the attached Document which looks at the spreadsheet "Transactions.xlsx", I am trying to do the Alternate States using the CustomerNo field but the chart is not changing, the expressions within the chart using Set Analysis and AGGR so I'm not sure if my syntax is right?</P><P></P><P>Anyone know how to do this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Comparative-Analysis-Alternate-State-Aggr-Set-Analysis/m-p/1416696#M805100 ivandrago 2020-11-25T16:16:04Z Re: Comparative Analysis Alternate State Aggr Set Analysis https://community.qlik.com/t5/QlikView/Comparative-Analysis-Alternate-State-Aggr-Set-Analysis/m-p/1416697#M805101 <HTML><HEAD></HEAD><BODY><P>Try the attached may be</P><P></P><P><STRONG>Sum({[Group1]} Aggr(Sum(DISTINCT {[Group1] &lt;[Status] = {'Open'}, [CustomerNo] = [Group1]::[CustomerNo]&gt;} [CreditLimit]), [Order No]))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Sum({[Group2]} Aggr(Sum(DISTINCT {[Group2] &lt;[Status] = {'Open'}, [CustomerNo] = [Group2]::[CustomerNo]&gt;} [CreditLimit]), [Order No]))</STRONG></P></BODY></HTML> Mon, 06 Nov 2017 00:54:29 GMT https://community.qlik.com/t5/QlikView/Comparative-Analysis-Alternate-State-Aggr-Set-Analysis/m-p/1416697#M805101 sunny_talwar 2017-11-06T00:54:29Z