topic Re: How to Match cells to get Rate in QlikView

How to Match cells to get Rate

Fri, 29 Aug 2014 17:38:45 GMT

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!!

Re: How to Match cells to get Rate

JonnyPoole — Fri, 29 Aug 2014 17:58:32 GMT

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])

Re: How to Match cells to get Rate

Fri, 29 Aug 2014 18:30:27 GMT

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