Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)?
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)
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
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)
After numerous trials, I finally got the And mode to work. Thanks.
I did use this in a chart, and it works as well. Thanks.