comparing items

[#1]

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)?

[sbaldwin]

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

[nagaiank · Accepted solution]

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)

[#4]

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

[#5]

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