I have a table with four columns: A, B, C, and D. I'd like to build a table that enables analysis on multiple occurrences of data in these columns. For example, if there are multiple instances of data in columns A, B and C, I'd like to see those, and a count, in my table. That's easy enough, but the analysis may call for the ability to find multiples on A,B,D; A,C,D; or A,B,C,D. (A will be held constant for now.) What I want to avoid is making four different charts.
The attached QlikView illustrates. It has a straight table that shows multiple occurrences on columns A, B, C and D. I'm looking for a way to make it more flexible as described -- i.e. the ability to exclude one of the columns in the analysis on multiples.
