Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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])
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])
Thank you very much that worked!!!!! I really appreciate it