Hi,
My requirement is When I select a patient name,it should copy the chart details, connect to R and genrate image and display that image in dashboard.
we are copying the chart data into excel file and connecting to R and convering this chart data into JPG file and laoding this image into Qlikview.
Wrote a macro:
1. Reading chart data and put in excel file in a local path in Qlikview(C:\Test\patient.xls)
2. Connected to R and converting this excel into JPG .Created a csv file for the patient name and JPG file.Through script I loaded this csv. file.
3. I kept ActiveDocument.Reload at last in my macro
Now based on patient name, image is channing in my desktop client. But when I kept the same file in accesspoint, image is not changing.
Based on patient name selection, excel file should be changed based on chart. But its not changing.
Finally from accesspoint, Qlikview is not connecting to R.
Can anyone help me ASAP.
Thanks,
Sahithya
