topic Re: Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/656910#M1077967 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try below,</P><P></P><P>Sum({1} Aggr(Max(If(MixMatch(FCRProduct,'Pegasys','Transplant','Nutropin','Lytics'), TerrCount)), FCRProduct))</P></BODY></HTML> Fri, 11 Jul 2014 03:27:38 GMT Anonymous 2014-07-11T03:27:38Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/656908#M1077965 <HTML><HEAD></HEAD><BODY><P>Can anyone please help me find out what is wrong with this expression</P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P>Sum<SPAN style="font-size: 8pt;">({1}(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">mixmatch</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">FCRProduct</SPAN><SPAN style="font-size: 8pt;">,'Pegasys','Transplant','Nutropin','Lytics'), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">max</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TerrCount</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">FCRProduct</SPAN><SPAN style="font-size: 8pt;">))))<BR /></SPAN></P></BODY></HTML> Fri, 11 Jul 2014 00:04:37 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/656908#M1077965 2014-07-11T00:04:37Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/656909#M1077966 <HTML><HEAD></HEAD><BODY><P>Hi Swati,</P><P></P><P>Try like this</P><P></P><P>=Sum({1}Aggr(If(mixmatch(FCRProduct,'Pegasys','Transplant','Nutropin','Lytics'), max(TerrCount)),FCRProduct))</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Fri, 11 Jul 2014 02:42:17 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/656909#M1077966 jagan 2014-07-11T02:42:17Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/656910#M1077967 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try below,</P><P></P><P>Sum({1} Aggr(Max(If(MixMatch(FCRProduct,'Pegasys','Transplant','Nutropin','Lytics'), TerrCount)), FCRProduct))</P></BODY></HTML> Fri, 11 Jul 2014 03:27:38 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/656910#M1077967 Anonymous 2014-07-11T03:27:38Z