I am trying to evaluate "R" using Qlik Sense. I have already configured "R" and started the Rserve, its working fine. I am using the Demo App and getting an error
"Rserve error: Error received from server: R parser:syntax error:
Can anyone help what am I missing
Below is the script I have
SET inputFile='$(QvWorkPath)\data\Comorbidity Inp ICD9 BBU.csv'; // Only needed for debugging/logging purposes.
SET outputFile='$(QvWorkPath)\data\Comorbidity Index BBU.csv'; // Only needed for debugging/logging purposes.
SET RSource = '$(Must_Include=$(QvWorkPath)\R\Comorbidity v2.R)';
LET RSource = Replace(RSource, '\', '\\'); // R needs double slashes.
// Extract all known ICD-9-CM diagnosis and procedure codes for each patient from the hospital data.
[icd9cm TEMP]:
LOAD PatientID as id,
'D' & Replace(AdmitICD9DiagnosisCD,'.','') as icd9cm
Resident [Hospital]
Where AdmitICD9DiagnosisCD <> 'UNKNOWN' and NOT IsNull(AdmitICD9DiagnosisCD);
LOAD PatientID as id,
'D' & Replace(PrimaryICD9DiagnosisCD,'.','') as icd9cm
Resident [Hospital]
Where PrimaryICD9DiagnosisCD <> 'UNKNOWN' and NOT IsNull(PrimaryICD9DiagnosisCD);
LOAD PatientID as id,
'P' & Replace(PrimaryICD9ProcedureCD,'.','') as icd9cm
Resident [Hospital]
Where PrimaryICD9ProcedureCD <> 'UNKNOWN' and NOT IsNull(PrimaryICD9ProcedureCD);
icd9cm:
NoConcatenate LOAD *
Resident [icd9cm TEMP]
Order By id;
DROP Table [icd9cm TEMP];
//STORE icd9cm INTO [$(inputFile)] (txt); // Uncomment to write out for debugging/logging purposes.
// Capture the number of ICD-9-CM diagnosis and procedure codes extracted from the hospital patient data.
LET vPatientICD9CodeCount = NoOfRows('icd9cm');
[Comorbidity Scores]:
NoConcatenate
LOAD
id as PatientID,
If(index <= 3, index, 5) AS [Comorbidity Score] // index is the field returned by the medicalrisk package function generate_charlson_index_df
Extension R.ScriptEval('$(RSource)', icd9cm{id, icd9cm});
DROP Table [icd9cm];
