How to Match cells to get Rate

[#1]

I am trying to get error rates.    Number of errors for a certain medication divided by total number of orders. I wanted help to see if there was a way I can load the two data sources and then have qlikview match the drugs and divide the numerator/denum.

Please see the attached file.

Example I want to be able to get the rate for ACETAMINOPHEN errors (585)/ACETAMINOPHEN medication orders 77914

so basically (585/77917)

How can I do this? Can someone please help me?? Please see the attached file.

Thanks so much!!

[JonnyPoole · Accepted solution]

need to join the tables first to establish context. Try changing your load script to the following to establish a join key on 'Med':

Data:

LOAD [Med],

     [Number of Errors]

FROM

(biff, embedded labels, table is [Sheet1$]);

left join (Data)

LOAD [Medication Orders] as [Med],

     [Sum of Med Orders]

FROM

(biff, embedded labels, table is [Sheet1$]);

then try  something like this in the chart expression:

Sum([Number of Errors])/sum( [Medication Orders])

[#3]

Thank you very much that worked!!!!! I really appreciate it