Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Match cells to get Rate

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

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

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

View solution in original post

2 Replies
JonnyPoole
Employee
Employee

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

Not applicable
Author

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