topic Re: comparing items in QlikView

comparing items

Fri, 06 Jul 2012 02:40:24 GMT

How would you set it up so that you can compare items from list (e.g. who has Item A but not Item B, who has Item A or Item C, who has Item Item A and Item D)?

Re: comparing items

sbaldwin — Fri, 06 Jul 2012 07:03:11 GMT

Hi if you wanted this in a chart you could use set analysis, for your 3 egs and the Person is what you are counting, what you are after is basicall an exclusion, a union and an intersection retrospecively ie:

count({$<Item = {'A'} > - $<Item = {'B'} > } Person)

count({$<Item = {'A'} > + $<Item = {'C'} > } Person)

count({$<Item = {'A'} > * $<Item = {'D'} > } Person)

Thanks

Steve

Re: comparing items

nagaiank — Sun, 08 Jul 2012 21:08:43 GMT

You may try using an And-Mode listbox. There are some criteria to be fulfilled while implementing it. The details are in the Qlikview Reference Manual (Search for And-Mode in List Boxes)

Re: comparing items

Thu, 16 Aug 2012 13:32:21 GMT

After numerous trials, I finally got the And mode to work. Thanks.

Re: comparing items

Thu, 16 Aug 2012 13:33:15 GMT

I did use this in a chart, and it works as well. Thanks.