I didn't have a chance to try to work through the problem discussed below until now. Thank you all for the answers. But I guess I wasn't clear enough with my example. "Women", among several other dimensions, are chosen from list boxes. So I can't simply sort on the field "women", I have to be able to use "Men" or "Women" depending on what is selected. Keep in mind my actual dimensions have dozens (or even thousands) of selections and I need to be able to look at one, or a multiple, or all of the selections. Thank you for any help.
Previous Thread:
"I am new to Qlikview, so please keep this in mind when answering.
My problem is that I am trying to create a table that will filter the numerator to all selections, but the denominator to only some. Specifically, I need a per capita number for a subset of a population and a total cost. So I want to be able to filter the population to one thing in the denominator, and filter the costs to the population, but also to a subset of total costs.
For example, if we have total money spent on fruit by people per person. But we want money spent on oranges by women. So we need to be able to filter the denominator to women, and the numerator to women and oranges.
I think this is the case for the Alternate States rather than Set Analysis, because you probably want flexibility what to select for numerator and what for denominator. Create one state for numerator, another for denominator, and use separate filters for states. Take a look at the Alternates States in "help".
