topic Re: Combining set expressions in QlikView https://community.qlik.com/t5/QlikView/Combining-set-expressions/m-p/111871#M510441 <HTML><HEAD></HEAD><BODY><P>Thank you Neelam! this is just the result that I needed (:</P></BODY></HTML> Wed, 08 Aug 2018 01:39:18 GMT Yintak 2018-08-08T01:39:18Z Combining set expressions https://community.qlik.com/t5/QlikView/Combining-set-expressions/m-p/111868#M510438 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I will like to seek help for this issue:</P><P></P><P><STRONG>=AGGR(Concat(DISTINCT [ChargeCode], ', '), [Job Number])</STRONG></P><P></P><P>Currently this is what I have for above, I will also like to combine another expression together:</P><P></P><P><STRONG>=If(Not Match(ChargeCode, 'AFC'), ChargeCode)</STRONG></P><P></P><P>What is the combination that I should use?</P><P></P><P>Please help, thank you!</P></BODY></HTML> Tue, 07 Aug 2018 06:21:43 GMT https://community.qlik.com/t5/QlikView/Combining-set-expressions/m-p/111868#M510438 Yintak 2018-08-07T06:21:43Z Re: Combining set expressions https://community.qlik.com/t5/QlikView/Combining-set-expressions/m-p/111869#M510439 <HTML><HEAD></HEAD><BODY><P>Did you try replacing the <SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>[ChargeCode] </STRONG></SPAN>in first expression with<SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG> <SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>If(Not Match(ChargeCode, 'AFC'), ChargeCode)?</STRONG></SPAN></STRONG></SPAN></P><P>Can you share a sample.</P></BODY></HTML> Tue, 07 Aug 2018 20:43:38 GMT https://community.qlik.com/t5/QlikView/Combining-set-expressions/m-p/111869#M510439 neelamsaroha157 2018-08-07T20:43:38Z Re: Combining set expressions https://community.qlik.com/t5/QlikView/Combining-set-expressions/m-p/111870#M510440 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=AGGR(Concat(DISTINCT </STRONG><STRONG style="color: #ff6600;">{&lt;ChargeCode -= {'AFC'} &gt;}</STRONG><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp; [ChargeCode], ', '), [Job Number])</STRONG></P></BODY></HTML> Tue, 07 Aug 2018 21:07:20 GMT https://community.qlik.com/t5/QlikView/Combining-set-expressions/m-p/111870#M510440 vishsaggi 2018-08-07T21:07:20Z Re: Combining set expressions https://community.qlik.com/t5/QlikView/Combining-set-expressions/m-p/111871#M510441 <HTML><HEAD></HEAD><BODY><P>Thank you Neelam! this is just the result that I needed (:</P></BODY></HTML> Wed, 08 Aug 2018 01:39:18 GMT https://community.qlik.com/t5/QlikView/Combining-set-expressions/m-p/111871#M510441 Yintak 2018-08-08T01:39:18Z