Hi,
I'm fairly new to Qlikview and this is my first time posting.
I have a table with a field called "Date", a field called"Category" (with the category name) and a field called "Cases for Category" (with the number of incidents related to that category on that date). Here is a simplified version of my data:
| Date | Category | Cases for Category |
| 1/1/2013 | Category A | 14 |
| 1/1/2013 | Category B | 7 |
| 1/2/2013 | Category A | 10 |
| 1/2/2013 | Category B | 4 |
| 1/3/2013 | Category A | 5 |
| 1/3/2013 | Category B | 2 |
| 1/4/2013 | Category A | 9 |
| 1/4/2013 | Category B | 4 |
I want to make a List Box where the field listed is "Category" and there is an expression next to it that represents what percent of incidents were related to that category for the seletected date range. So for example If I select 1/1/2013, I would like it to display this:
| Category A 66 |
| Category B 33 |
So far, I have an expression using set analysis to get a percent of the whole, however if I select specific dates, it only calculates the % of all the instances, not the instances for just those dates. Here's the expression:
Round(100 * Sum([Cases for Category])/(Sum(total{1 - $}[Cases for Category])+Sum(total{$}[Cases for Category])),0.01)
If I select just 1/1/2013 this is what I am getting now:
| Category A 25 |
| Category B 13 |
Can anyone help?
