Help creating a timeline

Fri, 28 Sep 2012 15:45:05 GMT

I'm trying to create a timeline to show the types of visits a patient has had in the last year. Right now I'm just using a small excel sample to load the data which includes the following fields:

PatientID, --5 different patients are included

DateOfService, -- random dates in 2012

TypeOfServiceCode, -- values 1-6 for different visits

TypeOfServiceDescrip

I tried to use a scatter plot so show the dates on the x-axis and the TypeOfServiceCode on the y-axis.

It worked to some degree but the issue is that the x-axis only shows the dates where the patient has a visit (reading them as text) and so there is not longitudinal spacing to show the gaps between visits.

I need help to get the x-axis to be a real timeline rather than a list of the visits.

Thanks!

topic Help creating a timeline in QlikView

Help creating a timeline