Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

comparing items

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

Tags (1)
1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: comparing items

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 Replies
sbaldwin
Contributor III

Re: comparing items

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
Valued Contributor III

Re: comparing items

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)

Not applicable

Re: comparing items

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

Not applicable

Re: comparing items

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

Community Browser