Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks in advance for any help.
You are a genius. I was looking for something similar and it worked in my scenario.