topic Re: Set Analysis Aggr Function in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Aggr-Function/m-p/1008527#M951453 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Aggr</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Count</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(<STRONG>{&lt;Source=, Destination1= &gt;} </STRONG></SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">DISTINCT</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Source</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)),</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Destination1</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)</SPAN></P></BODY></HTML> Mon, 30 Nov 2015 12:40:42 GMT swuehl 2015-11-30T12:40:42Z Set Analysis Aggr Function https://community.qlik.com/t5/QlikView/Set-Analysis-Aggr-Function/m-p/1008526#M951452 <HTML><HEAD></HEAD><BODY><P>I need to apply set analysis to this function, so that no other selection for Source or Destination1 will change the table.</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Source</SPAN><SPAN style="font-size: 8pt;">)),</SPAN><SPAN style="color: #800000; font-size: 8pt;">Destination1</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">How do I do that?</SPAN></P></BODY></HTML> Mon, 30 Nov 2015 12:36:44 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Aggr-Function/m-p/1008526#M951452 stjernvd 2015-11-30T12:36:44Z Re: Set Analysis Aggr Function https://community.qlik.com/t5/QlikView/Set-Analysis-Aggr-Function/m-p/1008527#M951453 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Aggr</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Count</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(<STRONG>{&lt;Source=, Destination1= &gt;} </STRONG></SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">DISTINCT</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Source</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)),</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Destination1</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)</SPAN></P></BODY></HTML> Mon, 30 Nov 2015 12:40:42 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Aggr-Function/m-p/1008527#M951453 swuehl 2015-11-30T12:40:42Z Re: Set Analysis Aggr Function https://community.qlik.com/t5/QlikView/Set-Analysis-Aggr-Function/m-p/1008528#M951454 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;">Or this:</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: #575757;"><STRONG>=Only({&lt;Source, Destination&gt;}</STRONG><STRONG>Aggr(Count(DISTINCT{&lt;Source, Destination&gt;} Source),Destination1</STRONG></SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style=": ; color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;">)</STRONG></SPAN></P></BODY></HTML> Mon, 30 Nov 2015 12:42:22 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Aggr-Function/m-p/1008528#M951454 sunny_talwar 2015-11-30T12:42:22Z Re: Set Analysis Aggr Function https://community.qlik.com/t5/QlikView/Set-Analysis-Aggr-Function/m-p/1008529#M951455 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Aggr</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Count</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(<STRONG style="font-style: inherit; font-size: 10.6667px; font-family: inherit;">{&lt;Source=, Destination1=,Date=,X= &gt;} </STRONG></SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">DISTINCT</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Source</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)),</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Destination1</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)</SPAN></P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Put Fields =, in your set analysis&nbsp; </SPAN></P></BODY></HTML> Mon, 30 Nov 2015 12:44:18 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Aggr-Function/m-p/1008529#M951455 raman_rastogi 2015-11-30T12:44:18Z