Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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