topic Set analysis in expression in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-in-expression/m-p/917266#M981987 <HTML><HEAD></HEAD><BODY><P>hi </P><P>I want to pass parameters through expression and i want to make those parameters embeded in set analysis</P><P></P><P>my exp is </P><P>sum(aggr(if(sum(bal)&gt;50000,1,0),customernbr))</P><P></P><P>in the above expression i want to make bal can be baleur,balusd,balRupee like and 50000 cn be varry</P><P></P><P>and my exp guranteecustomerno(baleur,50000) and <SPAN style="font-size: 13.3333330154419px;">guranteecustomerno(balusd,100000) like this for this two expressions i want to call above one only how to change above expression <STRONG>i.e </STRONG><SPAN style="font-size: 13.3333330154419px;"><STRONG>sum(aggr(if(sum(bal)&gt;50000,1,0),customernbr))</STRONG></SPAN></SPAN></P><P></P><P>please help in this issue.</P><P></P><P>Thanks,</P><P>MDR</P></BODY></HTML> Mon, 10 Aug 2015 09:55:39 GMT dasaradh 2015-08-10T09:55:39Z Set analysis in expression https://community.qlik.com/t5/QlikView/Set-analysis-in-expression/m-p/917266#M981987 <HTML><HEAD></HEAD><BODY><P>hi </P><P>I want to pass parameters through expression and i want to make those parameters embeded in set analysis</P><P></P><P>my exp is </P><P>sum(aggr(if(sum(bal)&gt;50000,1,0),customernbr))</P><P></P><P>in the above expression i want to make bal can be baleur,balusd,balRupee like and 50000 cn be varry</P><P></P><P>and my exp guranteecustomerno(baleur,50000) and <SPAN style="font-size: 13.3333330154419px;">guranteecustomerno(balusd,100000) like this for this two expressions i want to call above one only how to change above expression <STRONG>i.e </STRONG><SPAN style="font-size: 13.3333330154419px;"><STRONG>sum(aggr(if(sum(bal)&gt;50000,1,0),customernbr))</STRONG></SPAN></SPAN></P><P></P><P>please help in this issue.</P><P></P><P>Thanks,</P><P>MDR</P></BODY></HTML> Mon, 10 Aug 2015 09:55:39 GMT https://community.qlik.com/t5/QlikView/Set-analysis-in-expression/m-p/917266#M981987 dasaradh 2015-08-10T09:55:39Z Re: Set analysis in expression https://community.qlik.com/t5/QlikView/Set-analysis-in-expression/m-p/917267#M981988 <HTML><HEAD></HEAD><BODY><P>can somebody help on this</P></BODY></HTML> Tue, 24 Nov 2015 07:12:21 GMT https://community.qlik.com/t5/QlikView/Set-analysis-in-expression/m-p/917267#M981988 dasaradh 2015-11-24T07:12:21Z Re: Set analysis in expression https://community.qlik.com/t5/QlikView/Set-analysis-in-expression/m-p/917268#M981989 <HTML><HEAD></HEAD><BODY><P>Dear Dasaradh,</P><P></P><P>Kindly find attached document. I hope you are looking for that one.</P><P></P><P></P><P>Kind regards,</P><P>Ishfaque Ahmed</P></BODY></HTML> Wed, 25 Nov 2015 04:15:05 GMT https://community.qlik.com/t5/QlikView/Set-analysis-in-expression/m-p/917268#M981989 engishfaque 2015-11-25T04:15:05Z