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.