topic Re: Help with finding difference between two listboxes in QlikView

Help with finding difference between two listboxes

Fri, 22 Jan 2016 20:19:08 GMT

Hi All,

Can someone guide me to the right formula I can use to find the difference of values between the two listboxes? I want to be able to analyze the difference between Nov and Dec. I am using expression within the listboxes to get the customer ids in the two respected months. e.g. if(month=12, customerid). I have tried every formula and filtering in the book but the difference doesn't show. They two months have formed a some kind of a array where the difference doesn't budge.

Thanks in advance.

Re: Help with finding difference between two listboxes

swuehl — Fri, 22 Jan 2016 22:25:49 GMT

Maybe using a field expression like

=Aggr(Only({<customerid = p({<month ={11}>}) / p({<month = {12} >}) >} customerid), customerid)

Re: Help with finding difference between two listboxes

Fri, 22 Jan 2016 23:02:50 GMT

Hi Swuehl,

That formula works great. It provides me with the difference of the customer ids for both Nov and Dec. Is there anyway I can only find the customer ids missing in the month of Nov that are present in the month of Dec or the vice versa?

Thanks in advance

Re: Help with finding difference between two listboxes

erikzions — Fri, 22 Jan 2016 23:05:12 GMT

If it doesn't have to be a list box, you can use a straight table. First column for Nov. Second for Dec. Then a third to get the difference.

Re: Help with finding difference between two listboxes

swuehl — Fri, 22 Jan 2016 23:16:11 GMT

=Aggr(Only({<customerid = p({<month ={12}>}) - p({<month = {11} >}) >} customerid), customerid)

Re: Help with finding difference between two listboxes

Fri, 22 Jan 2016 23:35:33 GMT

Thank you everyone for your wonderful and timely feedback.