Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-09-28 11:45 AM

Help creating a timeline

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.

Capture.PNG

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!

1,090 Views
0 Likes
0 Replies