I think I've confused myself and I'm in need of help again. In the attached qlik file, you'll see the first chart (top left) as the count of some IDs, nothing special. The next chart is a sum of a particular count for the date that's the same as the first chart.
In the 3rd chart (below the other 2) you'll see I'm trying to do the division of (first chart)/(second chart), however because of the way the data is loaded, the chart is dividing by the sum of all the dates, rather than the sum for just 1 date each.
The solution I'm looking for, albeit perhaps counter-productive, should be within the way the data is loaded. I'm basically asking if it can be done, regardless if it's ideal.
Take a look at the qlik, and let me know if there are any questions.
